Excel Forum
Similar Content
Multi-Column ComboBox Drop Down Menus in Forms
Tutorial: Multiple columns of data within a UserForm ComboBox drop-down menu in Excel. I'll show you...
Sum Values that Equal 1 of Many Conditions across Multiple Columns in Excel
Tutorial: How to Sum values using an OR condition across multiple columns, including using OR with ...
Vlookup on Dates and Times in Excel
Tutorial: Perform a lookup on dates and times in Excel: vlookup, hlookup, index/match, any kind of l...

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.