XLOOKUP replaced VLOOKUP for me and honestly I don't know why I waited so long

Been using Excel for data work for a few years now and VLOOKUP was just muscle memory at this point. Last month I finally switched over to XLOOKUP on a project where I was pulling values from multiple sheets and man, it's a different experience.

No more locking in a column number that breaks the second someone inserts a column. XLOOKUP lets you reference the return range directly, it searches both left and right by default, and handling not-found errors is built right into the function instead of wrapping everything in IFERROR.

If you're still on VLOOKUP out of habit, try swapping it on your next task. The syntax clicks fast and you'll wonder why you held on so long.