Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

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

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunSun, October 30, 2022 8:36pm