vlookup does not always work

[Pablo]

Most of the time I am able successfully implement the
vlookup function. However, there are so few times when
everything looks good, I know there is a matching
reference, but my result is #N/A when I set the Range
lookup to FALSE. I have checked the field formats and
they both seem to match.

Any thoughts as to what is happening?

Thanks,
Pablo

 

[Peo Sjoblom]

Just because they seem to match does not mean they match,
there can be [not visible] things like spaces html characters etc..

 

[Richard Hoekstra]

I can't say I've got your answer but I've had problems
with the same. Usually due to formatting, and usually
because the formatting change I made did not take. I have
found I sometimes have to make the format change follwoed
by an f2 (edit) to edit the cell in question. only after
the edit does the formatting change stick. This is common
when dealing with a imported text file and the Text vs
General format selected during the import wizard needs to
be corrected.

Hope this helps
Rich

 

[Nishant]

hi,
it is not clear what exactly ur problem is,
but vlookup function will definetly work if u use trim
function in case of text,becoz vlookup will not recognize
the same text if there is different spacing b/w the same
text.
i think this will help u

regards
nishant