I'm having a problem finishing this formula to do what I want... (was going to do array formula but open to using anything that works!)
I've attch'd a small sample file to make it easy to understand using colors to show -- what should feed to where..
Need formula for G21
I tried to start with the following (CTRL+SHIFT+ENTER) array formula but not sure how to finish it off..
First it looks to O21 for the Month, then P21 for Year, then Q for Type, then
it should go to the "tables" sheet, within the named range table called: "droptableNEW" to locate those matches...
Once it finds all 3 matches, it should extract over the result found in the Q column of the "tables" sheet, from the NAMED RANGE called: "droptableNEW" and paste it into G21 of the SUMMARY tabforum.ozgrid.com/index.php?attachment/63789/