I would say that your data *doesn't* match, no matter how it might *appear*
to you.

Check out this page of Debra Dalgleish's, which shows a whole bunch of ways
to find and fix a probable *mismatch*:

http://www.contextures.com/xlFunctions02.html#Trouble
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"egamalaki" wrote
in message ...

I need help in vlookp. Excel returns #N/A when actually there should be
matching of information. Meaning the information am looking is present
in the other list but yet excel returns #N/A. If i am going hard code
the info, vlookup function correctly.

Please help


--
egamalaki
------------------------------------------------------------------------
egamalaki's Profile:
http://www.excelforum.com/member.php...o&userid=23858
View this thread: http://www.excelforum.com/showthread...hreadid=375019