An Excel Meditation with Tables, XLOOKUP, Dynamic Arrays in a Dynamic Dropdown List Solution

/in /by

During the Azerbaijan Power Bi & Modern Excel Meet-up last week, Faraz Shaikh presented and shared a lot of cool Excel tips. There was one tip that stood out for me: Extracting a table’s headers into a Dynamic Array. 😲 It was amazing! It got me thinking about how this could be applied.

In this video I show how to create a dynamic dropdown list that uses the table headers to extract specific data.
You’ll see: XLOOKUP, SORT, FILTER, TRANSPOSE in this solution.

The Azerbaijan Meet-up: https://www.meetup.com/baku-power-bi-modern-excel-user-meetup-group/

#XLOOKUP
#DynamicArrays
#MicrosoftExcel

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