Hello,
I'm attempting to integrate data between a "Master" sheet and a "Daily Entry" form. I'm trying to populate the "Quantity Completed" with the value in the "Parts Run" cell after successfully matching the Part Numbers in both sheets, circled in red. In a perfect world, an employee would enter their daily work report and press submit. Upon submission, the "Master" sheet would recognize the part number, look up the "Parts Run" cell for the corresponding Part Number, and add it to the Quantity Completed column cell.
So far, I've tried the following:
=INDEX({Daily Entry Range 4}, MATCH([Part Number]@row, {Daily Entry Range 3}, 0))
This returns a "NO MATCH"
I also tried:
=IF([Part Number]@row = {Daily Entry Range 1}, {Daily Entry Range 2})
This works partially, but only draws the "Parts Ran" data from a specific cell vs. from the cell corresponding the part number row.
Any help is greatly appreciated, this will be a terrific asset to assist with daily operational management. Thanks!
