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

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

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

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)

--
Biff
Microsoft Excel MVP


"Neslihan" wrote in message
...
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