VLOOKUP problem with using a -

M

MrSales

I've created a database with parts that have a - prefix before th
actual part number but it is returning n/a. It works fine if I don'
use a dash. Is there a way around this?

example

-04
-06
-08
-
 
K

Kevin Vaughn

You don't give very much detail, but I didn't have any problems. Are you
appending a "-" to what you are looking up? For instance:

=VLOOKUP("-"&J9,$H$10:$I$13,2,FALSE)
 
K

Kevin Vaughn

Or if instead you need to disregard the - from a value you are looking up
maybe you need something like this:

=VLOOKUP(MID(J9,2,LEN(J9)-1),$H$10:$I$13,2,FALSE)
 
Top