Chris Turner
New Member
I have a trying to create a formula using the INDEX and MATCH functions to do a daily update of a worksheet.
I want the formula to INDEX the most recent Part Numbers in Column C being run on a specific Molder in Column B in the OEE Report worksheet and to MATCH them with the Molders in Column A of the Master Downtime Analysis 2018 worksheet. I keep getting a #NAME? response.
I have tried several variations of this formula but not success so far:
=INDEX(OEE Report!$C:$C,MATCH($A4,OEE Report!$B:$B,0))
I was just trying to get the part numbers to load into the Master Downtime Analysis 2018 worksheet before I attempted to get the formula to insert the Part Numbers for Yesterdays date in Cells D1:D2
Appreciate any help with this.
I want the formula to INDEX the most recent Part Numbers in Column C being run on a specific Molder in Column B in the OEE Report worksheet and to MATCH them with the Molders in Column A of the Master Downtime Analysis 2018 worksheet. I keep getting a #NAME? response.
I have tried several variations of this formula but not success so far:
=INDEX(OEE Report!$C:$C,MATCH($A4,OEE Report!$B:$B,0))
I was just trying to get the part numbers to load into the Master Downtime Analysis 2018 worksheet before I attempted to get the formula to insert the Part Numbers for Yesterdays date in Cells D1:D2
Appreciate any help with this.