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)

--
Kevin Vaughn


"MrSales" wrote:


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

example

-04
-06
-08
-3


--
MrSales
------------------------------------------------------------------------
MrSales's Profile: http://www.excelforum.com/member.php...o&userid=32572
View this thread: http://www.excelforum.com/showthread...hreadid=546909