vlookup

[rrucksdashel]

Is there anyway to search a table indexing on a column that is to the left of
the column I am indexing on?

e.g. I want to find the Number (in case being 1) that is associated with
"A" in this table:

1 A
2 B
3 C

 

[Dave O]

=INDEX(A1:B3,MATCH(A5,B1:B3,0),1)
.... where your sample data is in A1:B3 and the letter A is in cell A5.

 

[Dave Peterson]

Another version:

=INDEX(A1:A3,MATCH(A5,B1:B3,0))

Debra Dalgleish's has some notes you may like at:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))