XLOOKUP vs VLOOKUP vs HLOOKUP

Показать описание

XLOOKUP vs VLOOKUP vs HLOOKUP!

XLOOKUP is a powerful EXCEL LOOKUP function because it can replace VLOOKUP and HLOOKUP.

XLOOKUP is a more versatile function that can handle both vertical and horizontal searches, and the lookup value does not have to be in the left column or first row.

XLOOKUP allows you to replace “error messages” with your own customized message or with a blank cell when a valid match is not found. In contrast, VLOOKUP and HLOOKUP only shows you a #N/A error.

In this video, you will learn the difference between XLOOKUP, VLOOKUP, and XLOOKUP function, and how to use each of them. These are the examples that are covered in this step-by=step tutorial:
1) Vertical lookup with VLOOKUP
2) IFERROR with VLOOKUP
3) Vertical lookup with XLOOKUP
4) Horizontal lookup with HLOOKUP
5) Horizontal lookup with XLOOKUP
6) If Not Found with XLOOKUP
7) Wildcard with XLOOKUP
8) Approximate lookup with XLOOKUP
9) Search Mode with XLOOKUP
10) Two-way Lookup with XLOOKUP

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 INDEX & MATCH
~ How to Use XLOOKUP in EXCEL!
~ How to use IFERROR in EXCEL
~ How to use HLOOKUP in EXCEL!
~ How to create a SALARY INCREASE MATRIX with EXCEL!
~ How to create a MERIT MATRIX to allocate salary increases!
~ How to use EXCEL INDEX Formula!
~ How to use EXCEL MATCH Function!
~ How to use SLICERS in EXCEL TABLE!
~ How to find PERCENTILE in PIVOT TABLE
~ How to create a 9 BOX GRID for TALENT MAPPING with SCATTER CHART!
~ COUNT FUNCTIONS IN EXCEL (COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS)
~ What is COMPA RATIO and how do you use it for pay decisions?

By Cedric Ng,
AUTHOR of International Best Sellers,
“Predictive HR Analytics, Text Mining & ONA with Excel” &
“IISS: Employee Experience & Engagement with Predictive Analytics”