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