Vlookup or Hlookup Uses for my 2 workbooks

B

Balkar Kalsi

Sir,

I have 2 workbooks (let us assume A.xls & B.xls) and having uniqu
Fields i.e. PCode & Qty. So, How do I update B.xls with same Qty o
A.xls against each Pcode ?

Regards
Balka
 
T

Toppers

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
 
Top