Reputation: 9891
I have:
and I want to calculate the numbers highlighted using a formula
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
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
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