XLOOKUP vs VLOOKUP & MATCH by Chris Menard

XLOOKUP is Excel's newest function. VLOOKUP with MATCH is very popular. In this video, I';; compare VLOOKUP/MATCH vs. XLOOKUP. I'll also show how to use wildcard searches in XLOOKUP.

XLOOKUP came out in late August 2019 and is only available to 50% of Office 365 insiders currently. XLOOKUP will be released to all O365 subscribers soon. Office 2019 and Office 2016 users will not get XLOOKUP.

Download the file for wildcards and Vlookup / Match vs XLOOKUP

XLOOKUP Wildcard searches required users to use the fourth argument in XLOOKUP. The wildcard is number 2. =XLOOKUP(C13&"*",B2:B9,F2:F9,2) After C13 is ampersand for join followed by the wildcard search, and the number 2 as the fourth argument. Most users may miss that they need to use the number 2 for the wildcard.

In my initial XLOOKUP video, I covered the six (6) things XLOOKUP will do that VLOOKUP will not do. I referenced the Microsoft technology article in that video and explained all six items in detail.

Here is a link to my previous XLOOKUP video: XLOOKUP - Six differences from VLOOKUP.

#xlookup #msexcel #vlookup #chrismenard #chrismenardtraining #excel

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[magicmanj]

I have office 365, I cant wait to play with xlookup lol

[stevenscotthager]

Hey Chris. Just signed up for Insider Fast. Don't yet see any changes in my installation so I can not test this question on my own. In your video just before 6 minute mark if you used a formula in an empty cell =F14 would it return West. I heard you say that not all INSIDER users have been given the XLOOKUP. Do you know how many days or weeks usually transpires before the Beta version is downloaded and or is there an easy way to force the download.