Script
Closed
jotowill
Posts
1
Registration date
Monday February 9, 2015
Status
Member
Last seen
February 9, 2015
-
Feb 9, 2015 at 02:14 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 9, 2015 at 11:45 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 9, 2015 at 11:45 AM
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 9, 2015 at 11:45 AM
Feb 9, 2015 at 11:45 AM
Hi Joe,
The formula you are looking for is called VLOOKUP.
Something like:
=VLOOKUP(A1,Sheet1!A1:B4,2)
When placed on sheet2 it will look for the value in A1. It will search the value in range A1:A4 of sheet1 and will return the value from the 2nd column of the given range A1:B4.
Best regards,
Trowa
The formula you are looking for is called VLOOKUP.
Something like:
=VLOOKUP(A1,Sheet1!A1:B4,2)
When placed on sheet2 it will look for the value in A1. It will search the value in range A1:A4 of sheet1 and will return the value from the 2nd column of the given range A1:B4.
Best regards,
Trowa
