Forum Discussion

Paq4035's avatar
Paq4035
Copper Contributor
Feb 20, 2019

IF Index Match problem?

I'm trying to set up a daily notification email that will pull data from a list that is added to daily and will include a minimum of four variables.  I had thought to use Index Match but can't make i...
excel
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Feb 23, 2019
You have to upload your sample file with the specific scenario of the output you want to achieve.
  • Paq4035's avatar
    Paq4035
    Copper Contributor
    Feb 25, 2019

    Thank you for the reply.  I have uploaded the worksheet with the problem.  I hope you or someone can help me.  

     

    Thanks again1

    • Paq4035's avatar
      Paq4035
      Copper Contributor
      Feb 25, 2019

      The actual data sheet will be thousands of lines long and may include as many as 24 machines or as few as 12 machines.  The product column could have a hundred different products and color is unlimited at this point.  I would like to have something that matches the date and the shift to the machine and brings back the product.  Then I could use the same formula to get the color that matches the product and then get it to enter the quantity in the last column.  The machine column can be pre-populated or not, the shift will always stay the same for the table, either first, second, or third.  I hope that makes sense.

       

      Thanks for any help.

      • Twifoo's avatar
        Twifoo
        Silver Contributor
        Feb 25, 2019
        The formula in D23 is: =IFERROR(LOOKUP(PI(), 1/(($B$3:$B$18=DateMatch)*($C$3:$C$18=B23)*($D$3:$D$18=C23)), $E$3:$E$18),"") All other formulas follow the same pattern. See them here in the attached file.