Formula for Column Number

F

FARAZ QURESHI

Is there any way to find out the column number within an array that matches
with the lookup value like the "Match" Function?
 
R

Ron Coderre

If you post your actual scenario, you'll get a more tailored response.

Absent that.....here's one way:

With
A1: (a value to lookup)

C1:Z1 contains values

This formula returns the column number of the first item in C1:Z1 that
matches A1
B1: =MATCH(A1,C1:Z1,0)+COLUMN(B1)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
Top