Previous Topic Next Topic

Formula 3 books open in excel

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

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

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