Vlookup text values

[YasserKhalil]

Hello
I have two columns A and B
In Column A there are numbers and in Column B there are names.
I want to type a formula which looks up a name and give me the number in column A....

[Trebor76]

Hi there,

You need a left lookup for that which the following achieves via the combination of the INDEX and MATCH functions:

=INDEX($A$2:$A$20,MATCH("Robert",$B$2:$B$20,0))

Just change the ranges to suit. Note the lookup item can be a cell if you like.

HTH

Robert