Hi Frank,

Am Tue, 21 Jul 2015 17:30:57 -0400 schrieb :

So, it seems it would be a straight forward solution. But there's
something with the formatting of the Product Numbers after being
extracted via the code below that errors out (#NA) the vlookup
formula. I've tried copy/pasting the column as text, as general, as
number, and doing the same to the numbers on Sheet2, to no avail. If
I take the exact same number on Sheet2 and paste it over the number on
Sheet1, then the formula works. The Product Number doesn't APPEAR to
change at all. But it does. Any thoughts on that? If I can't get
the product description, it's not the end of the world - this code
below gets me to where the users most basically need to be. But it
would be helpful to be able to add the description.

check the Product Number in sheet2 for leading or trailing spaces and
delete them with TextToColumns = Fixed Width = Finish.
If that is not the solution please provide some examples.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional