Excel Forum
Similar Content
Vlookup to Return All Matching Results
Tutorial: Here is an Excel formula that will act like a Vlookup that returns every matching result ...
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 ...
Multiply by True and False in Excel
Tutorial: You can multiply numbers by TRUE and FALSE in Excel. This effectively allows you to elimi...



Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH


Download file: http://people.highline.edu/mgirvin/
Two Lookup Values and Two Lookup Columns to Return Items to A Table Format
See how to lookup two items (two criteria) from two different columns and return a single item using a single cell formula (Does not require an extra column of concatenated values) and does not require Ctrl + Shift + Enter. See the functions INDEX, MATCH. See how INDEX function can take an array that requires Ctrl + Shift + Enter and if you leave the row argument blank, INDEX can deliver the array without Crtl + Shift + Enter.

Also see:

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





Got a Question? Ask it Here in the Forum.