I have the following formula that works very nicely. It finds the column number of the first value greater than 0 going from right to left in the range.

=LOOKUP(2,1/(MASTER_PLAN!C3:BZ3>0),COLUMN(MASTER_PLAN!C3:BZ3))

I would like to use an INDIRECT in place of the first range. If I use it in the second range only, it works. if I use it in the first, I get an error.

Ideas?


Thanks in advance!