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 guest. 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.
0:00 Introduction
0:24 My trip to Lagos
3:35 Using XLOOKUP to create the sum of a variable range
6:15 Using XLOOKUP to sum a variable range with variable start and end points
7:20 Using XLOOKUP and OFFSET to calculate variable distances
9:00 Outro
- Victor Momoh presenting at the Saudi Arabia Excel Meetup Group.
• The Versatile Lookup Functions with V...
- See Victor Momoh explain XLOOKUP returning a range instead of a value
• Getting Hyper with Hyperlinks | Victo...
- Victor's YouTube channel:
/ excelmoments
- Download the workbook in this video:
https://datascopic.net/momoh
#XLOOKUP #SumRange #CalculateDistance
For a list of my Excel courses at Lynda/LinkedIn:
/ oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My old blog: http://datascopic.net/blog-2-2