Master Sheet Data

Closed
Report
Posts
3
Registration date
Sunday October 18, 2015
Status
Member
Last seen
October 21, 2015
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
I have a master sheet on Excel with inventory of uniforms and who is assigned to each piece of uniform, ex: Gordon has #4 hat, #22 coat and #88 pant. The second sheet is sorted numerically by hat number and the person assigned to each hat. The third sheet is just coats and the last sheet is pants. My question is: If Gordon needs to replace his coat, how can I change just the master sheet with Gordon's new coat number and have the value change on the coat sheet just for Gordon?

I have 300+ uniforms I need to keep track of and I don't want to spend a lot of time changing each sheet, each line and risking errors. Thanks for your input.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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)
0
Posts
3
Registration date
Sunday October 18, 2015
Status
Member
Last seen
October 21, 2015

How does this change the data on all sheets? Isn't VLOOKUP just for locating data? I need to change the data on the master sheet and have that change reflected on the other sheets.
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
What I got is
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
0
Posts
3
Registration date
Sunday October 18, 2015
Status
Member
Last seen
October 21, 2015

I apologize. I am not a skilled excel user. Do I need to add vlookup to every row in my master sheet and every row in my other sheets as well?
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
i think if you try what i proposed, you would get a better idea. one learn more from mistake
0