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)


"Vladimir" wrote in message
...
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!