Previous Topic Next Topic

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
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

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
0

Similar discussions

Anu Script Manager 7 software for Windows 7
neelamnagaraja -
xpcman -

1 response
anu 7.0
ssk -
xpcman -

1 response
photoshop 7.0
viky -
Computertech -

1 response
Windows 7 Ultimate not activated
daarreehn -
Ambucias -

1 response
Windows Script Host: "Can't find script file..."
Moss -
xpcman -

3 responses