Lookup Two Criteria: SUMIFS, DGET, or Array Formula?
See Mr Excel and excelisfun lookup a value given two criteria. You will see three formulas: SUMIFS formula, DGET formula, and an array formula that uses MATCH & INDEX functions and concatenated (joined) cells and ranges. See how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.