VLOOKUP vs XLOOKUP: which one should you actually use?
VLOOKUP is the formula everyone learns first. XLOOKUP fixes nearly all of its problems. Here's a plain-English comparison and when to use each.
2 min read·By Microsoft Helper
Category
Excel
Formulas, pivot tables, charts and automation.