Report from Excel Data SheetSolved/Closed

Question

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.

TrowaD · Answer

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

ram sharma · Answer

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

TrowaD · Answer

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

Report from Excel Data Sheet

3 responses

Similar discussions

Subscribe To Our Newsletter!