Lookup Column Number

[John Bates]

Hi,

On sheet1 I have a list of Graphed Metrics (B3:B15) and I need a formula that will lookup each one of these metrics from row 2 of Sheet2 and then return the column number in cells C3:C15 of Sheet1.

Any ideas?

Thanks,
John

[Paul]

Hi John, to find the first column where that heading is found you could use this in C3 (and fill down):

=MATCH(B3,Sheet2!$2:$2,0)

[John Bates]

Thanks a ton!!!! That was exactly what I needed!!

-John