Excel 2-way Lookup with nested XLOOKUP #shorts

preview_player
Показать описание
XLOOKUP can be used for a 2-way lookup which is the equivalent of doing an INDEX with 2-MATCH functions.

link to workbook:
Рекомендации по теме
Комментарии
Автор

A true classic, XLOOKUP nesting. Thanks for sharing.

IvanCortinas_ES