How to use vlookup when lookup contains number and letters

G

Guest

I'm trying to use vlookup for a table I set up for looking up corresponding
prices based on item numbers. For example one of the item numbers is MGM005,
but when I set up the vlookup formula to reference the corresponding column,
which is price, it doesn't work. The vlookup only works for the item numbers
that are strictly numbers such as 001 or 004. If anyone knows how to resolve
this problem that would be great. Thanks
 
B

Biff

Do you have the range_lookup argument set to TRUE or 1? If so, change it to
FALSE or 0 (zero).

=VLOOKUP(A1,B1:D10,2,0)

Biff
 
G

Guest

Biff said:
Do you have the range_lookup argument set to TRUE or 1? If so, change it to
FALSE or 0 (zero).

=VLOOKUP(A1,B1:D10,2,0)

Biff




Thanks that did the trick.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for Range area within VLookup? 3
Embedded If Function in a Vlookup Function 2
is vlookup with an inverted start point possible? 9
using vlookup and hyperlink 6
VLookup is not working correctly 3
Lookup for this? 2
VLOOKUP with IF function 4
lookup column using text not col number 1

Top