copy emai datal to excel vlook

Microsoft Excel 2003 (full product)
May 24, 2010 at 05:46:12
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: copy emai datal to excel vlook

Report •


#1
May 24, 2010 at 08:45:14
Question was answered in the XP forum,

Your Product ID is probably be pasted as TEXT not real numbers.

MIKE

http://www.skeptic.com/


Report •

#2
May 24, 2010 at 10:10:33
What does a "product id" look like?

Report •

#3
May 25, 2010 at 04:47:47
something like
" WAE-SC002-25"
this is the product ID for bahbahbah

Report •

Related Solutions

#4
May 25, 2010 at 06:47:06
re: (100% sure the product ID is exactly the same from the excel database and email)

Try this:

Paste a product ID from an email into a cell, e.g. A1.

Locate that same product ID in your Excel list. Let's say it's located in A45.

Put this in a cell someplace:

=A1=A45

If it returns TRUE, then they are "exactly the same". If it returns FALSE then something is different.

Let us know what happens.


Report •

#5
May 25, 2010 at 08:31:46
It returns as "False".....oooo..........really different thing with the same product ID?
how can i make them identical format?help

Report •

#6
May 25, 2010 at 09:36:39
re: "how can i make them identical format?"

Since I can't see your spreadsheet from here, I can't answer that.

Obviously, you have to determine what is different. A leading space? A trailing space? A non-printing character? The possibilities are numerous.

One possible way to find the difference is as follows:

Put the ID from the email in A10

Put the ID from your list in A11

Put this in A1 and drag it across Row 1

=MID($A$10,COLUMN(),1) = MID($A$11,COLUMN(),1)

This will compare each character in the 2 strings, one by one, returning TRUE where they match and FALSE as soon as something different is found.

The COLUMN() function is used to determine the start_num for the MID() function. 1, then 2, then 3, etc.


Report •

Ask Question