CSV Files and VLOOKUP error

[ajpowers]

Does anyone know why VLOOKUP and Compare formulas don't work o
information originating from a CSV file? I've tried copying an
pasting values only (to leave behind any formatting), but it doesn'
help.

Through countless tests, I've narrowed it down to the CSV file bein
the only possible cause

 

[L. Howard Kittle]

Hi ajpowers,

Just a guess but the imported data may have leading or trailing spaces or
are numbers stored as text. You could use the formula =A1=D1 to see if you
get a true or false, where A1 is the lookup value and D1 ia the CVS value.
If false then sometin' aint da same.

HTH
Regards,
Howard

 

[ajpowers]

I don't understand the formula =A1=D1. Where am I supposed to typ
that? My information is on two different spreadsheets

 

[L. Howard Kittle]

Try something like this;

=A1=[Book1]Sheet1!$A$1

Where A1 is the lookup value on one sheet and [Book1]Sheet1!$D$1 is the
value to be looked up in the table on another Book and Sheet1.

If you are still having trouble with it I would be willing to look at the
two worksheets, if not sensitive material, and see if I can help.

HTH
Regards,
Howard

 

[L. Howard Kittle]

Try something like this;

=A1=[Book1]Sheet1!$A$1

Where A1 is the lookup value on one sheet and [Book1]Sheet1!$D$1 is the
value to be looked up in the table on another Book and Sheet1.

If you are still having trouble with it I would be willing to look at the
two worksheets, if not sensitive material, and see if I can help.

HTH
Regards,
Howard