Previous Topic Next Topic

Formula 3 books open in excel

Closed
NICKS37777
Posts
1
Registration date
Thursday November 1, 2012
Status
Member
Last seen
November 1, 2012
 - Nov 1, 2012 at 03:24 PM
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
 - Nov 2, 2012 at 02:23 AM
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

Answer 1 / 1
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
 69
Nov 2, 2012 at 02:23 AM
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.

0