Report from Excel Data Sheet

Solved/Closed
Report
-
 ram -
Dear Sir,

I am new in excel. I am trying to use excel for my work easier.
I have one excel file where there are different sheet of monthly salary of different employee. Employee may define unique ID.
May I use some VB formula (other if any) for knowing individual employee detail salary for different month.
I am so thankful if I found some help.

3 replies

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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
Sir

I am unable to see your answer.
what happen, Please suggest me.

thanks
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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
Thanks ,
I am able to done what I want to do.

ram