excelisfun | XLOOKUP Array Formula to Lookup Different Product Commission Rates for each Sales Rep. EMT 1804 @excelisfun | Uploaded 1 year ago | Updated 1 day ago
Download Excel File: https://excelisfun.net/files/EMT1801-1804.xlsx Geert Timing Workbook: https://excelisfun.net/files/EMT1801-1804_GDE001.xlsx
Learn how to
Topics:
1. (00:00) Introduction
2. (00:05) XLOOKUP Array Formula to create a Sales Rep Commission Report based on two Conditions for the commission rate.
3. (02:49) 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