XLOOKUP & Dynamic Arrays Celebration and Demos with MVPs Wyn Hopkins and Oz du Soleil

/in /by

XLOOKUP and Dynamic Arrays are finally available for anyone on Microsoft365 (formerly known as Office 365). In this video, Wyn Hopkins and I give you demonstrations of XLOOKUP and Dynamic Arrays working together to make simple but robust solutions.

0:00 Opening
1:34 Wyn’s Demo
6:15 Oz’s Demo
10:40 Wrap-up

You’ll see it all!
XLOOKUP
FILTER
2-way lookups
SORT
TRANSPOSE
Tables

It’s one big party, y’all!

#XLOOKUP
#Dynamic_Arrays
#DynamicArrays

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