Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP problem with using a -
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP problem with using a -
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP problem with using a -
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup problem | Excel Discussion (Misc queries) | |||
Vlookup problem with Date Time | Excel Worksheet Functions | |||
vlookup Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Problem | Excel Worksheet Functions | |||
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions |