I've never had trouble with dashes. Is it possible that you have numeric values
formatted to include dashes either in the table or in the lookup value (with the
opposite being text?)



anthonyn wrote:

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

--

Dave Peterson