FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801

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

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