Excel XLOOKUP Comparison with VLOOKUP and HLOOKUP
In this vireo we are going to talk about XLOOKUP. This was a request from my dear viewer "Mireille Cantrell" who wrote me: "I've used VLOOKUP() and HLOOKUP() for years but would like to be as comfortable using the new XLOOKUP()".
I prepared several samples on this video to try to cover most of the business cases. I'll compare several usages between VLOOKUP/HLOOKUP and XLOOKUP to help you in understand it better.
-------------------------------------------------------------------
Links
▶ XLOOKUP() Function Explained: https://bit.ly/3gDx6m4
▶ File used in this video: https://bit.ly/3nehYOU
▶ Playlist all about Excel Tricks: http://bit.ly/excel_playlist
-------------------------------------------------------------------
Features Explained
XLOOKUP() compared to VLOOKUP()
XLOOKUP() compared to HLOOKUP()
XLOOKUP() N/A Handling
XLOOKUP() Match Mode
XLOOKUP() Match Mode with Wildcards
XLOOKUP() Two-Way Lookup
XLOOKUP() Search Mode
-------------------------------------------------------------------
Content Breakdown
Intro & Business Case - 00:00
XLOOKUP() Background and Availability - 01:03
XLOOKUP() vs VLOOKUP() Sample #1 - 02:48
XLOOKUP() vs VLOOKUP() Sample #2 - 05:18
Bonus #1 - How to easily find the # of columns in your VLOOKUP() range - 05:33
XLOOKUP() vs VLOOKUP() Sample #2 (Cont.) - 02:48
XLOOKUP() vs HLOOKUP() Sample - 07:39
XLOOKUP() Match Mode - 09:35
XLOOKUP() Match Mode with Wildcard - 13:21
Super Bonus - Two-Way Lookup - 16:19
XLOOKUP() Search Mode - 19:51
Bonus #2 - Spreadsheet detailing all XLOOKUP variations - 22:32
Thank You! - 20:05
-------------------------------------------------------------------
Trick Stats
Complexity: ⭐⭐⭐⭐
This formula usage is new and there are too many variations, specially on the last 2 parameters. The usage on the is not straight forward.
Performance: ⭐
This formula is not about enhancing performance.
Organization/Control: ⭐⭐
You will be able to analyze for data as XLOOKUP now makes the LOOKUP concept in excel a little more flexible.
Deliverable: ⭐⭐
You will be able to deliver better analysis for the same reason explained above.
-------------------------------------------------------------------
A little background about myself
I'm a Program Manager working for a prestige world-wide IT and Telecom corporation, present in more than 100 countries and having more than 35 thousand employees. I'm 8 years working for this company and within this period I managed to grow from a technician to a Director and be relocated several times. All of these before 40's. I was only 35 years old when I was relocated to USA and only 36 years old when I was promoted to Direction level. My ultimate goal is to teach you my path, how I managed to do it, my right choices and the bad ones as well, to short the several years long corporate journey from expert to Director into just few years. Among several skills you have, dominating MS Office was one of the success keys to call attention to my efficiency, organization and outstanding results delivered.
-------------------------------------------------------------------
Let's get in touch
▶ e-Mail: [email protected]
▶ Web: http://officetothepoint.com (Under Construction)
▶ LinkedIn: / diogoroldao
▶ YouTube: / @diogoroldao-officetothepoi610
▶ Instagram: / diogo_rpc
▶ Facebook: / diogo.rpc
▶ Twitter: / diogoroldao
#XLOOKUP #Vlookup #Hlookup #officetothepoint #diogoroldao
