Excel Forum

Excel Magic Trick 757.5: Two Lookup Columns Or Sum With Two Criteria?

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn about the difference between looking up a value when there are two lookup values and adding values when there are two criteria. See the functions INDEX, MATCH, SUMPRODUCT and SUMIFS
This video is in response to:
Excel Magic Trick 757: Two Lookup Values and Two Lookup Columns? Great Formula INDEX & MATCH

Got a Question? Ask it Here in the Forum.