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

more info

--
Don Guillett
SalesAid Software

"MrSales" wrote in
message ...

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

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

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)
--
Kevin Vaughn


"Kevin Vaughn" wrote:

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