Adding numbers once
Closed
SCPCP
-
Oct 29, 2010 at 02:12 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 4, 2010 at 10:21 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 4, 2010 at 10:21 AM
Related:
- Adding numbers once
- Adding accent to e - Guide
- Adding watermark in word - Guide
- Adding second controller to ps5 - Guide
- Adding authorized user t mobile - Guide
- Adding a tick in word - Guide
4 responses
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Oct 29, 2010 at 06:53 PM
Oct 29, 2010 at 06:53 PM
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 September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 1, 2010 at 10:34 AM
Nov 1, 2010 at 10:34 AM
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 September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 4, 2010 at 10:21 AM
Nov 4, 2010 at 10:21 AM
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
