XLOOKUP v3.0; Power Query Import from Web; Intellisense, Text.Length

/in /by

We put a lot together in this superbly delicious Excel tutorial. We start with the revised XLOOKUP version 3.0 which has the “if not found” component moved to the 4th position instead of the 6th.

Then we move to import data from a webpage and clean the data using Power Query’s FILL Down, Text.Length and other feature. Then, the final component in this deliciousness is a Left Outer Join. It’s all here for your delight.

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

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

#XLOOKUP
#PowerQuery
#MSExcel