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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.