Hello,

I'm having a problem with my vlookup formula so I could use some help. I
have already confirmed that the formatting is the same in the two lists
(Format is Number- General). I have also confirmed that there are no leading
or trailing characters using the LEN() formula. When I pastespecial- formats
between the referenced cells, the lookup does not work but, when I paste the
referenced cells, then the lookup works. The problem is that I don't want to
paste 1,000 separate times.

Any other ideas? For example, when I do a lookup on sku 123, Excel returns
nothing (no #ERROR and no #NA).

SKU QTY
123 200
087 10

Thanks for your help.
Scott