lookup

[Peter1973]

Im trying to et the formula for the following.

In A1:Z1 i have numbers

I want the formula to look in cell AA1 find the column in A1:Z1 with the matching number then reurn the value in row 2, but i need to copy thi formula down so the next one returns the value in row 3 and so on.

any help appreciated.

 

[Jonmo1]

Try this

=INDEX(A2:Z2,MATCH(AA$1,A$1:Z$1,0))

 

[shemayisroel]

Peter this may help

http://www.contextures.com/xlFunctions03.html