Check register with VLookup
Closed
Jude2007
Posts
1
Registration date
Friday July 7, 2017
Status
Member
Last seen
July 7, 2017
-
Updated on Jul 7, 2017 at 06:06 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 13, 2017 at 11:51 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 13, 2017 at 11:51 AM
Related:
- Check register with VLookup
- Check soft - Download - Finance
- Tmobile check balance - Guide
- Speaker check code - Guide
- Yahoo register - Guide
- How to check if someone is spying on my whatsapp - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jul 13, 2017 at 11:51 AM
Jul 13, 2017 at 11:51 AM
Hi Victor,
I think you are looking for this formula:
=VLOOKUP(C2,$A$2:$B$5,2)
It will look for Victor (C2) in column A and then returns the value from column B (2nd column of the matrix A2:B5).
Best regards,
Trowa
I think you are looking for this formula:
=VLOOKUP(C2,$A$2:$B$5,2)
It will look for Victor (C2) in column A and then returns the value from column B (2nd column of the matrix A2:B5).
Best regards,
Trowa