Formula 3 books open in excel

[Closed]
Report
Posts
1
Registration date
Thursday November 1, 2012
Status
Member
Last seen
November 1, 2012
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
I have 3 books open in excel
(Book 1) I would like to make my template.
(Book 2) is a spreadsheet of stores.
(Book 3) is a spreadsheet of operators.

I would like to enter an ID # in column A of (Book 1) and have information from
(Book 2) B - F of that corresponding # copied to (Book 1) C - G.

If I enter an ID # in column B of (Book 1) to have her information from
(Book 3) B - F of that corresponding # copied to (Book 1) C - G.



1 reply

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
46
Hi NICKS37777,

In order update Book 1 from Book 2 and Book 3 using the ID #, you can use vlookup() worksheet function. For more information on how to use vlookup(), you can refer the following link:

http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

Please revert for clarification.