The formula does not seem wrong to me. #N/A means excel does not find
the match. Also check column A on both sheets and see if they are
entered differently in format.

One example is when someone entered the number with ' in front, ie.

'162955

Even you retype it as 162955 after, Excel still does not read it
properly somehow. At least that's what it is in Excel 97.




navneetjn Wrote:
That didnt help!!
Thanks anyway. Does it have to do anything with the fact that I am
using Excel 97.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=388108