Use Microsoft 365 functions FILTER and XLOOKUP to lookup different commission rates for each product by Sales Rep.
Topics:
- (00:00) Introduction
- (00:09) FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep
- (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
More about Excel Features
What are the XLOOKUP & VLOOKUP functions in Excel?
The XLOOKUP and VLOOKUP functions in Excel are used to find, or 'lookup', a value from a table or a list and then return a related result. In this resource, we’ll discuss XLOOKUP vs VLOOKUP with examples of how to use each.
https://www.goskills.com/Excel/Resources/Xlookup-vs-vlookup
XLOOKUP just killed VLOOKUP: everything to know about this major new Excel function
Microsoft recently announced the upcoming release of a new function called XLOOKUP. This function will be replacing the widely used VLOOKUP, HLOOKUP and INDEX/MATCH functions to run searches in a table of Excel data.
https://www.powerusersoftwares.com/post/xlookup-just-killed-vlookup-everything-to-know-about-this-major-new-excel-function