Hi Jacob,

Try doing something like this:

=VLOOKUP("*"&A1&"*",TEXT(B1:G100,"0"),2,0)

This is an ARRAY formula (Ctrl+Shift+Enter)

Regards,
KL


"JACOB" wrote in message
...
i HAVE ALOOK UP RANGE THAT HAS IN THE 1ST COLUMN NUMBERS & OR NUMBERS &
LETTERS THE vLOOK UP ONLY GIVES ME THE NUMBERS IT GIVE n?A ON THE ALPHA OR
ALPHA NUMERIC
I HAVE THEM FORMATTED AS GENERAL IN BOTH LOCATIONS