Download Excel File: https://excelisfun.net/files/EMT1801-1804.xlsx Peter B Lambda solution: https://excelisfun.net/files/EMT1801-1804PeterB.xlsx
Use Microsoft 365 functions FILTER and XLOOKUP to lookup different commission rates for each product by Sales Rep.
Topics:
1. (00:00) Introduction
2. (00:09) FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep
3. (02:54) 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