HOW TO SOLVE INDEX MATCH WITH DATE TENURE?

HOW TO SOLVE INDEX MATCH WITH DATE TENURE?

This is Table 1

This is Table 2


The criteria is Match the Date & Name from Table 1 to find the Amount and put it in Table 2. And also add the amounts which is under the date tenure for the specific month.

After many research I have found a formula which can mach 2 criteria at once but its not working for add the amounts for specific date tenure.

{=IFNA(INDEX($C$2:$C$8,MATCH(1,(($A$2:$A$8=$E2)*($B$2:$B$8>DATE(2020,1,31))*($B$2:$B$8<DATE(2020,3,1))),0)),0)}

Please help me to add the amounts which will have in the date tenure.

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Abhijit,

    Is this for Excel or Smartsheet?

    Do you want to convert it from Excel to Smartsheet?

    I hope that helps!

    Be safe and have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.