Formula for Column Number
 

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

Formula for Column Number
 

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


"FARAZ QURESHI" wrote:

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