2-WAY LOOKUPS (XLOOKUP vs INDEX & MATCH)!

2-WAY LOOKUPS (XLOOKUP vs INDEX & MATCH)!

XLOOKUP and INDEX & MATCH are both powerful lookup solutions in Excel. INDEX & MATCH can do 2-way LOOKUPS, but you’ll need 2 formulas (INDEX and MATCH). XLOOKUP is a powerful Excel lookup function because it can replace VLOOKUP, HLOOKUP, INDEX & MATCH, and IFERROR. XLOOKUP function can do what INDEX and MATCH does but with just 1 formula, and XLOOKUP has built-in error handling (so you don't need to use the IFERROR formula). In this video, you will learn how to use EXCEL’s INDEX and MATCH, and XLOOKUP function, using these examples.
1) How to use "INDEX" formula
2) How to use "MATCH" formula
3) How to use "INDEX & MATCH" formula together for “2-WAY LOOKUPS”
4) How to do "VERTICAL LOOKUP" with "XLOOKUP" formula
5) How to do "VERTICAL LOOKUP" with "XLOOKUP" formula and "If NOT FOUND"
6) How to do "HORIZONTAL LOOKUP" with "XLOOKUP" formula
7) How to use "Nested XLOOKUP" formula for "2-WAY LOOKUPS"

If you find the video useful, subscribe to “The HR Diary” YouTube channel. Subscribing to YouTube channels is free, and you will be updated when new contents are uploaded.

Other related resources to this video:
~ XLOOKUP vs VLOOKUP vs HLOOKUP
   • XLOOKUP vs VLOOKUP vs HLOOKUP  
~ How to Use XLOOKUP in EXCEL!
   • How to Use XLOOKUP in EXCEL!  
~ How to use HLOOKUP in EXCEL!
   • How to use HLOOKUP in EXCEL!  
~ How to use EXCEL INDEX Formula!
   • How to use EXCEL INDEX Formula!  
~ How to use EXCEL MATCH Function!
   • How to use EXCEL MATCH Function!  
~ How to use SLICERS in EXCEL TABLE!
   • How to use SLICERS in EXCEL TABLE!  
~ How to find PERCENTILE in PIVOT TABLE
   • How to find PERCENTILE in PIVOT TABLE  
~ How to use PIVOT TABLE (Including how to add Filter, Slicer & Pivot Chart)    • How to use PIVOT TABLE!  
~ How to FIND MEDIAN in PIVOT TABLE    • How to FIND MEDIAN in PIVOT TABLE  
~ How to DISPLAY TEXT in PIVOT TABLE!    • How to DISPLAY TEXT in PIVOT TABLE (S...  
~ How to create a 9 BOX GRID for TALENT MAPPING with PIVOT TABLE!    • How to create a 9 BOX GRID for TALENT...  
~ How to create a 9 BOX GRID for TALENT MAPPING with SCATTER CHART!
   • How to create a 9 BOX GRID for TALENT...  
~ How to create a GANTT CHART with EXCEL    • How to create a GANTT CHART with EXCEL  
~ How to create a SALARY STRUCTURE with EXCEL    • How to create a SALARY STRUCTURE with...  
~ SUMIF in Excel    • SUMIF in Excel  
~ COUNTIF in Excel    • COUNTIF in Excel  
~ How to use GOAL SEEK for GRADES    • How to use GOAL SEEK for GRADES  
~ COUNT FUNCTIONS IN EXCEL (COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS)
   • COUNT FUNCTIONS IN EXCEL (COUNT, COUN...  
~ SUMIFS in EXCEL    • SUMIFS in EXCEL  
~ How to use VLOOKUP for GRADES    • How to use VLOOKUP for GRADES  
~ EXCEL with ChatGPT:    • EXCEL with ChatGPT  
~ VLOOKUP with CHATGPT    • VLOOKUP with CHATGPT (How to generate...  

By Cedric Ng,
AUTHOR of International Best Sellers,
“Predictive HR Analytics, Text Mining & ONA with Excel” &
“IISS: Employee Experience & Engagement with Predictive Analytics”
~ Subscribe to my YouTube channel at :    / thehrdiary  
~ Follow my Facebook page at :   / thehrdiary  
~ Check out Books at : https://www.amazon.com/s?k=ng+mong+shen