Report from Excel Data Sheet
Solved/Closed
Related:
- Report from Excel Data Sheet
- Transfer data from one excel worksheet to another automatically - Guide
- How to screenshot excel sheet - Guide
- Crystal report viewer - Download - Data management
- Little alchemy cheat sheet - Guide
- Mark sheet in excel - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
May 17, 2011 at 10:15 AM
May 17, 2011 at 10:15 AM
Hi Ram,
Yes you may.
Phew, that was an easy question. haha
Try Vlookup.
=Vlookup(Employee name, Matrix of employee's and salary's, column in which the salary is found).
Use help for more info on Vlookup.
Does this help?
Best regards,
Trowa
Yes you may.
Phew, that was an easy question. haha
Try Vlookup.
=Vlookup(Employee name, Matrix of employee's and salary's, column in which the salary is found).
Use help for more info on Vlookup.
Does this help?
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
May 19, 2011 at 09:08 AM
May 19, 2011 at 09:08 AM
Hi Ram,
Strange, can you see it now?
Try Vlookup.
=Vlookup(Employee name, Matrix of employee's and salary's, column in which the salary is found).
Use help for more info on Vlookup.
Does this help?
Best regards,
Trowa
Strange, can you see it now?
Try Vlookup.
=Vlookup(Employee name, Matrix of employee's and salary's, column in which the salary is found).
Use help for more info on Vlookup.
Does this help?
Best regards,
Trowa