<VLOOKUP giving me a glitch

Yes, and maybe many others.

If some of them contain letters, it is probably better to make them all text.

=text(a1,"0") or some other formatting string


--
Kind regards,

Niek Otten

"gacollege" wrote in message
...

I have a list of 1,000 values 900 are numeric values and 100 of them are
text values. What problems could arise when working with this list? I
know sorting will not put part 1001 and 1001-ST together, but at one
time I recall VLOOKUP giving me a glitch when trying to pull data from
a list of numeric and text values.

Richard


--
gacollege
------------------------------------------------------------------------
gacollege's Profile: http://www.excelforum.com/member.php...fo&userid=1518
View this thread: http://www.excelforum.com/showthread...hreadid=521639