Adding numbers once
Closed
SCPCP
-
29 Oct 2010 à 14:12
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 4 Nov 2010 à 10:21
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 4 Nov 2010 à 10:21
Related:
- Adding numbers once
- Adding days to a date in excel - Guide
- Adding a checkmark in word - Guide
- Adding emojis to outlook - Guide
- Adding hard drive - Guide
- Adding shortcut to desktop - Guide
4 responses
RayH
Posts
122
Registration date
Tuesday 31 August 2010
Status
Contributor
Last seen
20 June 2016
26
29 Oct 2010 à 18:53
29 Oct 2010 à 18:53
Given your example, can you supply an expected outcome?
It would help to formulate an answer.
It would help to formulate an answer.
Once I put the number in sheet one I want that number to go to sheet two with the correct name. So I only have to enter the number once.
Thanks
Thanks
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
1 Nov 2010 à 10:34
1 Nov 2010 à 10:34
Hi Andy,
The formula for sheet2's B1 you are looking for is:
=VLOOKUP(A1,Sheet1!$A$1:$D$4,2,FALSE)
Then select B1 again and change A1 into $A$1 like:
=VLOOKUP($A$1,Sheet1!$A$1:$D$4,2,FALSE)
Now drag B1 right till D1.
Change the formula of B1 back to:
=VLOOKUP(A1,Sheet1!$A$1:$D$4,2,FALSE)
Select C1 and change formula in:
=VLOOKUP(A1,Sheet1!$A$1:$D$4,3,FALSE)
Select D1 and change formula in:
=VLOOKUP(A1,Sheet1!$A$1:$D$4,4,FALSE)
Now select B1:D1 and drag it down till B4:D4 and you are done.
You can put $ signs manually or use F4 to cycle through the different notifications.
Best regards,
Trowa
The formula for sheet2's B1 you are looking for is:
=VLOOKUP(A1,Sheet1!$A$1:$D$4,2,FALSE)
Then select B1 again and change A1 into $A$1 like:
=VLOOKUP($A$1,Sheet1!$A$1:$D$4,2,FALSE)
Now drag B1 right till D1.
Change the formula of B1 back to:
=VLOOKUP(A1,Sheet1!$A$1:$D$4,2,FALSE)
Select C1 and change formula in:
=VLOOKUP(A1,Sheet1!$A$1:$D$4,3,FALSE)
Select D1 and change formula in:
=VLOOKUP(A1,Sheet1!$A$1:$D$4,4,FALSE)
Now select B1:D1 and drag it down till B4:D4 and you are done.
You can put $ signs manually or use F4 to cycle through the different notifications.
Best regards,
Trowa
Thank you TrowaD
However I am running into a problem and I think I made a mistake in my example. I can get the first number to populate however after that I get this error message"#REF!". The new example is below
Sheet 1
Bob 1
Jill 2
Paul 3
Frank 4
Jill 5
Paul 6
Frank 7
Bob 8
Paul 9
Frank 0
Bob 9
Jill 8
Frank 7
Bob 6
Jill 5
Paul 4
Sheet 2
Bob 1 8 9 6
Jill 2 5 8 5
Paul 3 6 9 4
Frank 4 7 0 7
However I am running into a problem and I think I made a mistake in my example. I can get the first number to populate however after that I get this error message"#REF!". The new example is below
Sheet 1
Bob 1
Jill 2
Paul 3
Frank 4
Jill 5
Paul 6
Frank 7
Bob 8
Paul 9
Frank 0
Bob 9
Jill 8
Frank 7
Bob 6
Jill 5
Paul 4
Sheet 2
Bob 1 8 9 6
Jill 2 5 8 5
Paul 3 6 9 4
Frank 4 7 0 7
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
4 Nov 2010 à 10:21
4 Nov 2010 à 10:21
Sorry Andy, I don't know a solution for this setup.
Once you need the data on sheet2, you could sort the data on sheet1 and then transpose it to sheet2, but that isn't what you aksed for.
Good luck finding a solution.
Best regards,
Trowa
Once you need the data on sheet2, you could sort the data on sheet1 and then transpose it to sheet2, but that isn't what you aksed for.
Good luck finding a solution.
Best regards,
Trowa
