Using unique number to filter information
Closed
kermitchell
Posts
1
Registration date
Tuesday June 26, 2012
Status
Member
Last seen
June 26, 2012
-
Jun 26, 2012 at 06:54 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 28, 2012 at 09:26 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 28, 2012 at 09:26 AM
Related:
- Using unique number to filter information
- Safe search filter - Guide
- Filter unknown senders android - Guide
- Apply snapchat filter to existing video - Guide
- Snapchat black and white filter - Guide
- Viber video call filter - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jun 28, 2012 at 09:26 AM
Jun 28, 2012 at 09:26 AM
Hi Kermitchel,
Have you tried VLOOKUP?
To retrieve the name:
=VLOOKUP(A2,Sheet1!$A$2:$D$2,2)
To retrieve the payroll no:
=VLOOKUP(A2,Sheet1!$A$2:$D$2,3)
etc...
"A2" is the location of the voucher no on sheet 2.
"Sheet1!$A$2:$D$2" is the matrix to look at.
"2" will be the column of the matrix to retrieve info from.
Change range(s) to suits your data.
Best regards,
Trowa
Have you tried VLOOKUP?
To retrieve the name:
=VLOOKUP(A2,Sheet1!$A$2:$D$2,2)
To retrieve the payroll no:
=VLOOKUP(A2,Sheet1!$A$2:$D$2,3)
etc...
"A2" is the location of the voucher no on sheet 2.
"Sheet1!$A$2:$D$2" is the matrix to look at.
"2" will be the column of the matrix to retrieve info from.
Change range(s) to suits your data.
Best regards,
Trowa