Two Way Lookup with XLOOKUP & Summary Report with SUMIFS. Excel Magic Trick 1802

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1801-1804.xlsx
Use functions SUMIFS and XLOOKUP to lookup different commission rates for each product by Sales Rep.
Topics:
1. (00:00) Introduction
2. (00:12) XLOOKUP to do a two-way lookup
3. (02:08) SUMIFS to add with one condition
4. (02:43) Summary, Closing, Video Links

FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801
SUMIFS & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1802
LAMBDA & MAP Functions to Lookup Different Product Commission Rates for each Sales Rep. EMT 1803
XLOOKUP Array Formula to Lookup Different Product Commission Rates for each Sales Rep. EMT 1804

ExcelIsFunSun, October 30, 2022 8:36pm