hi tom,
That was true.. now its working and shows the lookup value not found..
that means it cant get the value.. its there in the answer sheet and i
dont know y this shows the error..
is it neccessary that the value that is to be searched and the value in
the sheet should be of same format..
coz.. the value in the Answer sheet is general and the in the other
sheet is number...


--
bisjom
------------------------------------------------------------------------
bisjom's Profile: http://www.excelforum.com/member.php...o&userid=31206
View this thread: http://www.excelforum.com/showthread...hreadid=508799