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

Microsoft Excel Tips and Tricks

Learn how to create an advanced array formula to spill two-way lookup results using INDEX and MATCH function.

Credit ExcelIsFun