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
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.
    • Paq4035's avatar
      Paq4035
      Copper Contributor
      Feb 26, 2019

      Thank you!  I am very grateful.  You've saved me a lot of time and headache.

      • Twifoo's avatar
        Twifoo
        Silver Contributor
        Feb 26, 2019
        It’s my pleasure to help you.