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
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
462
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
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
462
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!