email to excel vlook

Microsoft Excel 2003 (full product)
May 23, 2010 at 11:03:21
Specs: Windows XP
I create a excel database file with vlook up function. It's sort of a stock list with product ID and name stuffs. someone send me several items with product ID via outlook. When I tried to paste those product ID to the vlook template to look up for the product name, it didn't work nothing is showing up.(100% sure the product ID is exactly the same from the excel database and email) . It worked when I type the product ID to the template. Is it something deal with code or format? Can anyone help me ? I don't wanna enter 600 product ID to excel for product name. Need you folks help !!!!! THANKS

See More: email to excel vlook

Report •

May 23, 2010 at 15:25:51
Excel questions are best asked in the Office Software forum.

That being said, it sounds like when you copy & paste, the Product ID numbers being pasted as TEXT not real numbers.


Report •

May 23, 2010 at 16:03:00

Report •
Related Solutions

Ask Question