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
Hi Joe here,
Sheet 1 Data
A B
1001 HE
1002 SHE
1003 HIS
1004 HERS
When I type the values from column A in sheet 2 I must get the value from Column B
For eg: when I type 1003 on the adjacent cell I should get HIS
Thanks
Sheet 1 Data
A B
1001 HE
1002 SHE
1003 HIS
1004 HERS
When I type the values from column A in sheet 2 I must get the value from Column B
For eg: when I type 1003 on the adjacent cell I should get HIS
Thanks
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