Another VLOOKUP question

[Ela]

This is my first at this forum...

For some reason my VERY SIMPLE Vlookup formula is not producing result
- I can see the field that should be matched and it's still coming u
as N/A.

Here it is:

I have two sets of two columns. Each has product number and $amount i
a separate column.

Column A and B and Column D and E.

I want to list all products in A that are found in C.

I put a curser in C1 and I am doing =VLOOKUP(A1,D,1,FALSE).

It's not working - all comes up as N/A even though I can see the sam
values in both columns staring at me. I used to do these a couple o
years ago and it worked - but I don't know if I have to put the on
different spreadsheet, or in a certain order on a page?

HELP!

Thanks,
El

 

[Frank Kabel]

Hi
try
=VLOOKUP(A1,$C$1:$D$1000,2,FALSE)

But I'm not so sure where your two list are stored??
could you post one example row of your data (plain text please)

 

[Ela]

Thanks! Someone at work told me that the imported file had 'invisible
spaces between the digit, so it actually was something else from wha
it appaered... I used the 'trim' function to clean it up and i
worked!

Thanks,
El