Sheet in which the next column gets automatically filled
Closed
JyotirmoyGuha
Posts
1
Registration date
Tuesday July 14, 2015
Status
Member
Last seen
July 14, 2015
-
Jul 14, 2015 at 04:34 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 14, 2015 at 11:41 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 14, 2015 at 11:41 AM
Related:
- Sheet in which the next column gets automatically filled
- Little alchemy cheat sheet - Guide
- Google sheet right to left - Guide
- Excel copy column from one sheet to another automatically - Guide
- Mark sheet in excel - Guide
- Download automatically while roaming - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jul 14, 2015 at 11:41 AM
Jul 14, 2015 at 11:41 AM
Hi JyotirmoyGuha,
The VLOOKUP formula will look for a value (employee name) in a matrix (a table with employee names and ID's) and then return the value of a chosen column in the matrix.
Try it and let us know if and where you get stuck.
If I didn't understood you correctly then please provide a sample of your data for better understanding.
Best regards,
Trowa
The VLOOKUP formula will look for a value (employee name) in a matrix (a table with employee names and ID's) and then return the value of a chosen column in the matrix.
Try it and let us know if and where you get stuck.
If I didn't understood you correctly then please provide a sample of your data for better understanding.
Best regards,
Trowa
