Hi ,
I am making a format of salary slip using index and match function.
i am trying that if i put the month and emp. id the rest data should come automatically to that payslip format. but i have 12 worksheet having 12 month salary on it. and in that i have already made table of the salary made for particular month naming the table name.
now i want to use index formula for all the worksheet and match formula in such a way that if i just put the month and emp id i get the pay slip made for the particluar employee.
my every worksheet has the below header:-
emp id | name | month | lwp | salary payable |
1 | praveen | may'18 | 1 | 18000 |
2 | deepak | may'18 | 0 | 9000 |
<tbody>
</tbody>
this is may month salary worksheet. like this i have 11 more month salary work sheet.
and i have made a format of payslip in which i have put all the details.i am trying for a formula through which if i just put month and emp id ,i get the data in the desire colums of that payslip from the desired worksheet.
Plz can u help.