Vlookup or Hlookup Uses for my 2 workbooks
 

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

Vlookup or Hlookup Uses for my 2 workbooks
 

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