VLOOKUP vs XLOOKUP: Which One to Use, and How to Switch

By the end of this page you can write both lookup formulas, read either one in someone else's workbook, and pick between them on purpose. You will know the three specific ways VLOOKUP returns a wrong