Hello,

I am new to Excel Forum and I am not very advanced in Excel. I hope someone can help me with this.

I am building a payroll workbook and I need to build a sheet that will allow me to choose an employee name and a date. The multiple values returning are the details of this particular employee and week of work. It could return multiple lines, as one employee can have two entries relating to the same week.

I found a formula that uses INDEX and MATCH which is giving good results, but my workbook is on multiple sheets (one sheet per month). I don't know how to build a formula that can look into all 12 sheets and return the appropriate data.

I have built a workbook example : Test formula on payroll.xlsx
The example is a simpler version with only 3 months. The "Payslip" sheet is where I need to build the formula.

Thanks for your help.