TheEdge
TheEdge

Reputation: 9891

Formula to calculate the column number

I have:

enter image description here

and I want to calculate the numbers highlighted using a formula

enter image description here

NOTE the ordering of the values in the first image AND the second image vary over time.

Match does not appear to do the trick.

Upvotes: 0

Views: 71

Answers (2)

MGP
MGP

Reputation: 2551

Since you only want the column number, MATCH should suffice:

=MATCH(A2,Sheet1!$1:$1,0)

Where Sheet1 is the first sheet, where you keep the names in the row

Upvotes: 1

krib
krib

Reputation: 569

Wouldn't INDEX and MATCH solve this? im not to sure if I got the question, but if you want to get the values over to the first sheet I would put this in row 2 in the first sheetINDEX(A:B,MATCH(A$1,'SHEET2'!A:A,0),2) and drag out as you wish.

Upvotes: 0

Related Questions