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

3-Way Lookup Adding: XLOOKUP or INDEX inside SUMIFS? –- Excel Magic Trick 1602

Posted on by Annie D

Download Excel File (to follow along with video): https://ift.tt/306B9CN
Learn about how to use three lookup values to lookup values and then add. The trick is that two of the lookup values are in the records and one is in the Column Headers. See how to lookup a column with XLOOKUP or INDEX and MATCH functions, then but the resultant range object into the SUMIFS Function.

View on YouTube

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.