Two Lookup Values for Excel Lookup? Two Examples: FILTER or INDEX? – Excel Magic Trick 1590

Download Excel File:
Learn how to lookup up an item based on two lookup values. See two methods: FILTER Function or INDEX Function. Learn about the join operator to join the two lookup values and to join the two lookup columns.

View on YouTube