Hi,

I am trying to use the choose function to solve an other problem I am having, but I dont know or havnt worked with choose very much & having a hard time wrapping my head around how to do this. This is what I got:
Formula: copy to clipboard
=CHOOSE(INDIRECT(ADDRESS(BJ3,COLUMN(BL3)))<>"",COLUMN(BL3),COLUMN(AO3))

I dont think I am doing it right. It gives me Col 63s & then Blanks instead of the other Col