Excel Forum
Similar Content
Return the Min or Max Value Using a Lookup in Excel - INDEX MATCH
Tutorial: Find the Min or Max value in a range and, based on that, return a value from another rang...
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Mat...
Wildcards in Excel
Tutorial: Wildcards are characters that allow you to make more robust functions, searches, and filt...



Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples)


See how to lookup and then add values with three criteria using 2 methods:
1. Add helper column that joins two criteria, SUMIF function, Ampersand to join criteria, INDEX and MATCH function to retrieve entire column of values (3rd criteria).
2. SUMPRODUCT and joining columns and matching joined criteria and , INDEX and MATCH function to retrieve entire column of values.

Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm





Got a Question? Ask it Here in the Forum.