Forum Discussion
Solved
need help with a formula
- I have a excel sheet that has an employee's Provident fun deduction amount per month from the starting date
- Now I need to bring “from which month and year an employee has started to deduct his Provident fund amount” in another summary sheet from that data series.
- Please help me with the formula
The formula that I posted will only work in Excel 365 / 2021. The following version should work in older versions too:
=INDEX($D$2:$AM$2,MATCH(TRUE,D3:AM3>0,0)) & ", " & INDEX($D$1:$AM$1,QUOTIENT(MATCH(TRUE,D3:AM3>0,0)-1,12)*12+1)
Confirm with Ctrl+Shift+Enter.
- Attach a sample file then we could suggest formula for you. I assume VLOOKUP, INDEX/MATCH, XLOOKUP, FILTER all of these function can give you desired result.
