Sum variable and custom ranges with XLOOKUP: the Victor Momoh Edition

I was on a couple of Meetup Zoom calls and Victor Momoh was the host. He showed some fascinating stuff by using XLOOKUP to retrieve a range of data. He then used it to make sums and all kinds of other cool things. I share some of that in this video with you.

– Victor Momoh presenting at the Saudi Arabia Excel Meetup Group.

– See Victor Momoh explain XLOOKUP returning a range instead of a value

– Victor’s YouTube channel:
https://www.youtube.com/c/ExcelMoments/videos
– Download the workbook in this video:
https://datascopic.net/momoh
For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2