Vlookup Function

[davidzan]

How to use the VLOOKUP function by using a "STRING" source instead of "NUMERICAL" source? Thanks

 

[frabulator]

Please elaborate. Do you mean column names, like "A", "B" instead of "1" and "2", or do you mean look for values as strings like "Orange"?

 

[awoohaw]

if string is in cell A2 and the Lookup range is D2:F10, and you want the 2nd column, matching exactly:

=VLOOKUP(A2,$D$2:$F$10,2,0)

 

[davidzan]

Please elaborate. Do you mean column names, like "A", "B" instead of "1" and "2", or do you mean look for values as strings like "Orange"?

RE: =vlookup(John Doe,$A$5:$C$20,2)

 

[Joe4]

Literal text MUST always be enclosed in double-quotes, i.e.

=vlookup("John Doe",$A$5:$C$20,2)

This is true in any/all Excel functions.

 

[davidzan]

if string is in cell A2 and the Lookup range is D2:F10, and you want the 2nd column, matching exactly:

=VLOOKUP(A2,$D$2:$F$10,2,0)

if string is in cell A2 and the Lookup range is D2:F10, and you want the 2nd column, matching exactly:

=VLOOKUP(A2,$D$2:$F$10,2,0)

Please elaborate. Do you mean column names, like "A", "B" instead of "1" and "2", or do you mean look for values as strings like "Orange"?

Value as a string like "Orange"

 

[davidzan]

Literal text MUST always be enclosed in double-quotes, i.e.

=vlookup("John Doe",$A$5:$C$20,2)

This is true in any/all Excel functions.

Fantastic. Thanks so much!!! I didn't consider the quotation marks. It's now understandable.

 

[Joe4]

You are welcome.
Glad we were able to help!