Master Sheet Data
Closed
banjomomma
Posts
3
Registration date
Sunday October 18, 2015
Status
Member
Last seen
October 21, 2015
-
Oct 18, 2015 at 07:51 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 21, 2015 at 02:15 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 21, 2015 at 02:15 PM
Related:
- Master Sheet Data
- Master royale - Download - Strategy
- Yu-gi-oh master duel download pc without steam - Download - Strategy
- Typing master mod for pc - Download - Education
- Windows network commands cheat sheet - Guide
- Google sheet right to left - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 20, 2015 at 02:31 PM
Oct 20, 2015 at 02:31 PM
you can use vlookup to pull up the name from the master sheet
Master sheet
A1= "Gordon"
B1=#4 hat
C1=#22 coat
D1=#88 pant.
E1= =A1 (formula to make name also the last column to allow use of vlookup)
Coat Sheet
A1=#22 coat
B1 = VLOOKUP(A1, 'Master sheet'!C:E,2, FALSE)
Master sheet
A1= "Gordon"
B1=#4 hat
C1=#22 coat
D1=#88 pant.
E1= =A1 (formula to make name also the last column to allow use of vlookup)
Coat Sheet
A1=#22 coat
B1 = VLOOKUP(A1, 'Master sheet'!C:E,2, FALSE)
Oct 21, 2015 at 09:39 AM
Oct 21, 2015 at 10:31 AM
1. there is a master sheet where you have all the name, and the assignments of articles
2. for each ariticle, you have a separate sheet
3. you would like each article sheet, to show that name to whom that particular article has been assigned.
Vlookup, is showing the updated information in each article sheet, based on the data on the master sheet
This is how i read your question. Is this not what you seek
Oct 21, 2015 at 01:38 PM
Oct 21, 2015 at 02:15 PM