| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
dashes in vlookup
I am using vlookup to lookup quantities attached to part numbers. The formula works fine unless the part number contains a dash (-) then it will not find the part number in the table array even though they look identical. I have tried formatting the cells in various ways but it has made no difference. Any ideas?? Thanks, Tony -- anthonyn ------------------------------------------------------------------------ anthonyn's Profile: http://www.excelforum.com/member.php...o&userid=16753 View this thread: http://www.excelforum.com/showthread...hreadid=319553 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
| carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
| VLOOKUP not working | Excel Worksheet Functions | |||
| Using Cell references in VLookUp | Excel Worksheet Functions | |||
| vlookup. | Excel Worksheet Functions | |||
Threaded Mode
