Thanks a lot Kostis, Gord & Scott. The VLOOKUP thing gave me hope coz it
pulls up data for the next 2 consecutive columns, but for the rest of
the columns its comes up with #N/A.
I am not sure as to why this is hapenning. I did look into a web
tutorial for vlookup and it was excatly as you guys had mentioned. But,
still no go !
I am attaching a sample master sheet of 200 logs from one supplier. PLs
havea look and tell me what I am doing wrong. IN the attached excel
sheet, GRN No. is the Goods Receipt Note No.
Thanks a lot for all the help u guys are giving me.
Cheers,
Ajit
+-------------------------------------------------------------------+
|Filename: Sample.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=4118 |
+-------------------------------------------------------------------+
--
Newtonboy
------------------------------------------------------------------------
Newtonboy's Profile:
http://www.excelforum.com/member.php...o&userid=29582
View this thread:
http://www.excelforum.com/showthread...hreadid=492821