INDEX & XMATCH functions to spill a Two-Way Lookup Formula. Excel Magic Trick 1760 Part 2.

Posted on by Annie D

Learn how to create an advanced array formula to spill two-way lookup results using INDEX and MATCH function.
Topics:
1. (00:00) Introduction.
2. (00:14) Formula
3. (02:03) Thanks to Excel Lambda for this formula!

ExcelIsFunTue, October 12, 2021 7:45pm