Vlookup Help needed ASAP

V

Vladimir

I am having trouble looking up the Text (String) in the list the contains the
same text (string)
For example, one list contains "Sam Smith", and the other list contains "Sam
Smith", but Vlookup() returns #N/A.

Please help!
 
P

Peo Sjoblom

Probably an extra space somewhere, check one cell for each with =LEN(cell)
replace cell with one Sam Smith cell reference then do it with one form the
other list,
if no extra spaces it should return 9 in both cases, if you have more in one
case
wrap the range in TRIM like

=VLOOKUP(A2,TRIM(Sheet2!A2:C100),2,FALSE)

entered with ctrl + shift & enter

or

=VLOOKUP(TRIM(A2),Sheet2!A2:C100,2,FALSE)

entered normally

you might want to install this macro

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

that will remove trailing html characters as well

--
Regards,

Peo Sjoblom

(No private emails please)
 
R

Richard Buttrey

I am having trouble looking up the Text (String) in the list the contains the
same text (string)
For example, one list contains "Sam Smith", and the other list contains "Sam
Smith", but Vlookup() returns #N/A.

Please help!
Click to expand...

Apart from any additional spaces that others have mentioned, is the
list a multicolumnar list and is "Sam Smith" in the first column?

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
V

Vladimir

"Vladimir" пишет:
I am having trouble looking up the Text (String) in the list the contains the
same text (string)
For example, one list contains "Sam Smith", and the other list contains "Sam
Smith", but Vlookup() returns #N/A.

Please help!
Click to expand...

Yes, I have used the Trim() function and yes "Sam Smith" is in first column
in the list of lookup values. Also, I have changed the formating of both
columns, i.e. format to text values.
I don't know what else could be done to find the solution.
 
R

Richard Buttrey

"Vladimir" ?????:


Yes, I have used the Trim() function and yes "Sam Smith" is in first column
in the list of lookup values. Also, I have changed the formating of both
columns, i.e. format to text values.
I don't know what else could be done to find the solution.
Click to expand...

Have you tried copying Sam Smith from your lookup table to the cell
which you're using for the lookup?

If that still returns #N/A at least you'll have eliminated a text
string problem.

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
P

pisanichris

When using VLOOKUP, you should have the data in the first column sorte
(Data, Sort). Try this and it should work. Make sure you select all th
table and sort by 1st column. If you don't want to sort the data fo
other reasons, try using the LOOKUP function rather than the VLOOPKUP
 
Top