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.



Related:

1 response

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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response