Is there a function to get column # of cell with matching value

N

Neslihan

Hi,

I would like to write a function that will bring out the column index number
for a cell containg a particulat lot #, i.e.

A B C
1 3 366
5 2 22


What function do I need to use that will determine the column index # for
the cell containing the value of "366"??


Thanks,

Neslihan
 
T

T. Valko

Try this array formula** :

=MAX((A1:C2=366)*COLUMN(A1:C2))

If there are multiple instances of 366 the formula will return the rightmost
column number.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
 
Top