Try:
Put in B2 on Sheet1 (or whatever) in B.xls, assuming Pcode & Qty are in
columns A & B in both workbooks.
=VLOOKUP(A2,[A.xls]Sheet1!$A:$B,2,FALSE)
HTH
"Balkar Kalsi" wrote:
Sir,
I have 2 workbooks (let us assume A.xls & B.xls) and having unique
Fields i.e. PCode & Qty. So, How do I update B.xls with same Qty of
A.xls against each Pcode ?
Regards
Balkar
--
Balkar Kalsi
------------------------------------------------------------------------
Balkar Kalsi's Profile: http://www.officehelp.in/member.php?userid=4604
View this thread: http://www.officehelp.in/showthread.php?t=1222650
Posted from - http://www.officehelp.in