Mastering XLOOKUP\n\nStop using VLOOKUP. XLOOKUP is the modern way to find data in Excel. It is more flexible and powerful.\n\n## Why use XLOOKUP?\n- It can look left.\n- It defaults to an exact match.\n- It doesn't break when you add columns.\n\n=XLOOKUP(lookup_value, lookup_array, return_array)