I know that what I'm trying to do is easier than I'm making it out to be, but I've gotten myself wrapped around the axle and can't get my brain to work properly.
I have as small data table with a list of "batches", what date those batches were built, and what workstations they were built on.
I have a second set of tables that resemble a calendar where I need to pull in the batches that were built on particular workstations on specific dates.
In the example below, the yellow shaded cells in E4:E6 need to pull in the batch numbers that were built on workstation MN(F1) and were built on 8/18/2014(E2).
I need the formulas to pull in ALL batches on the day they were built as is shown in cells E11:E13.
I’ve used as many combinations of INDEX and MATCH that I can muster but only get it to pull the 1st instance of the workstation and date instead of ALL instances.
{=INDEX(Table_BuiltData,MATCH(1,(Table_BuiltData[workstation]=$A$1)*(Table_BuiltData[builtdate]=E$2),0),3)}
Any help would be greatly appreciated!
I have as small data table with a list of "batches", what date those batches were built, and what workstations they were built on.
I have a second set of tables that resemble a calendar where I need to pull in the batches that were built on particular workstations on specific dates.
In the example below, the yellow shaded cells in E4:E6 need to pull in the batch numbers that were built on workstation MN(F1) and were built on 8/18/2014(E2).
I need the formulas to pull in ALL batches on the day they were built as is shown in cells E11:E13.

I’ve used as many combinations of INDEX and MATCH that I can muster but only get it to pull the 1st instance of the workstation and date instead of ALL instances.
{=INDEX(Table_BuiltData,MATCH(1,(Table_BuiltData[workstation]=$A$1)*(Table_BuiltData[builtdate]=E$2),0),3)}
Any help would be greatly appreciated!
Last edited: