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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if function help 5
avoid nested IFs with another function 4
match function with nested if 12
INDEX & MATCH find first column value in an array? 3
MYSTERY: NESTED INDEX AND MATCH FUNCTIONS 29
Have the need to sort text code-values within same Excel cell 2
Lookup / Index/Match 3
Index, match, multiple IFs query 9

Back
Top