XLOOKUP and the XLOOKUP Perth Peace Summit

/in /by

XLOOKUP is finally here! We have formally declared an end to the VLOOKUP vs. INDEX/MATCH drama. XLOOKUP gives us so much more power and flexibility than VLOOKUP and it’s a single formula unlike INDEX/MATCH which is a nested formula of 2 functions with their own syntax and quirks.

This video gives you a small taste of XLOOKUP. Also, this includes footage of the emergency XLOOKUP Peace Summit where fellow Excel MVP, Wyn Hopkins, and I signed a Declaration of Peace, ending the VLOOKUP vs INDEX/MATCH squabbling.

XLOOKUP will live on!

#XLOOKUP
#VLOOKUP
#INDEXMATCH

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