Try it with a TRIM around the lookup value:
=VLOOKUP(TRIM(A1),Sheet1!A:B,2,FALSE)
There could be extraneous white spaces here and there throwing apparent
matches off (this is quite common). And if the above still doesn't do it,
then you need to TRIM the vlookup's reference col ie Sheet1's col A as well.
Use a helper col to TRIM in Sheet1 (eg in Sheet1, in E1=TRIM(A1), copy down),
then copy the helper col and overwrite Sheet1's col A. Success? hit the YES
below
--
Max
Singapore
---
"klmiura" wrote:
Yes, Eva that is what I have and I receive #N/A for the result...I even made
sure they were all spelled exactly the same and in the same upper/lower case.
Any other suggestions?