| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you link HLOOKUP AND VLOOKUP formulas and return their interce | Excel Worksheet Functions | |||
| Index / Hlookup | Excel Worksheet Functions | |||
| dynamic, double vlookup, match, index, dget?? different workbooks | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| formula using both vlookup & hlookup | Excel Worksheet Functions | |||
Linear Mode
