Row\Col A B C D E F G 1ITEM QTY LOCATION BIN LOC_TO_MATCH BIN_TO_MATCH ITEMS_MATCHED 2Item 1 -1Location 1 Bin 1 Location 3 Bin 2 Item 3 3Item 2 1Location 2 Bin 1 Item 5 4Item 3 -1Location 3 Bin 2 Item 7 5Item 4 1Location 3 Bin 2 6Item 5 -1Location 3 Bin 2 7Item 6 1Location 3 Bin 1 8Item 7 -1Location 3 Bin 2 9Item 8 1Location 4 Bin 1 10Item 9 -1Location 2 Bin 2 11Item 10 1Location 3 Bin 1
Using the table above as an example, I am looking for help with a formula (probably array) for column "E". The column should list all of the items from column "A" that matches the following two criteria:
Criteria 1: A negative value in column "B".
Criteria 2: Column "C" match with cell "$E$2".
Criteria 3: Column "D" match with cell "$F$2".
The current values in column "G" are an example of what the array formula would return given the current values in "$E$2" & "$F$2".
Thanks in advance for the help!
Bookmarks