XLOOKUP Function | Excel One Minute Functions Explained

XLOOKUP is one of my favorite functions in Excel! If you use VLOOKUP frequently, you should try XLOOKUP. Unlike VLOOKUP, XLOOKUP can look left and right. With XLOOKUP, if you add or delete columns, XLOOKUP still works. There are many other reasons to use XLOOKUP over VLOOKUP. This one-minute video has two examples. I have a blog post showing six reasons why XLOOKUP is better than VLOOKUP.

XLOOKUP Videos by Chris Menard
Xlookup function    • XLOOKUP Function |  Excel One Minute ...  
XLOOKUP vs. VLOOKUP & MATCH    • XLOOKUP vs VLOOKUP & MATCH by Chris M...  

And make sure you subscribe to my channel!

- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

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!