A twist to my earlier array problem
Posted by Russell Hauf on November 20, 2001 11:36 AM
Referring to the formula:
that was given as an answer to my earlier post (link below),
could I change this formula to dynamically select a column other than D? So suppose I want to use cell G1 on Sheet2 to hold the column number of the number I want to return.
So the part that needs to change is:
I know that I could use the ADDRESS function along with FIND, LEFT, and COLUMN to change the D, like LEFT(ADDRESS(1,COLUMN($G$1),2),FIND("$",C50)-1) --
and then use INDIRECT to change function where the D1:D10 is, but is there a better way?