I am trying to do a vlookup, I have alist of part numbers that are text
and some are numbers. The aray is going to a list with the same values
that are text and numbers to give me a text value.
=VLOOKUP(A144,[Book1]Sheet1!$A$1:$D$17174,4,FALSE)

When it looks up the numbers on the list it gives me my lookup value,
when it gets to the text part numbers ex (S#######/#####A) I get a #n/a
error. Why am I getting this error? Is there something I can use that
will lookup text and numbers that are on the same list?


--
robertjtucker
------------------------------------------------------------------------
robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805
View this thread: http://www.excelforum.com/showthread...hreadid=509540