Tag Archives: VLOOKUP

VLOOKUP vs XLOOKUP, What’s the Difference and When to Use Them

VLOOKUP vs XLOOKUP, What’s the Difference and When to Use Them thumbnail

The “new” XLOOKUP function was introduced in Excel 2021 and Office 365, and improves upon the heavily used VLOOKUP function in several ways. Let’s start by reviewing the syntax and an example of each function to understand the differences, starting with VLOOKUP.   VLOOKUP Syntax and Examples Here is the syntax: VLOOKUP (lookup_value, table_array, col_index_num,…
Read More

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.

Categories