Why every Excel user should replace VLOOKUP with XLOOKUP today

Why I ditched VLOOKUP for XLOOKUP—and made Excel predictable again Credit: Tony Phillips/How-To Geek By  Tony Phillips Published May 31, 2026, 9:30 AM EDT Tony Phillips is an experienced Microsoft Office user with a dual-honors degree in Linguistics and Hispanic Studies. Prior to starting with How-to Geek in January 2024, he worked as a document producer, data manager, and content creator for over ten years, and loves making spreadsheets and documents in his spare time. Tony is also an academic proofreader, experienced in reading, editing, and formatting over 3 million words of personal statements, resumes, reference letters, research proposals, and dissertations. Before joining How-To Geek , Tony formatted and wrote documents for legal firms, including contracts, Wills, and Powers of Attorney. Tony is obsessed with Microsoft Office! He will find any reason to create a spreadsheet, exploring ways to add complex formulas and discover new ways to make data tick. He also takes pride in producing Word documents that look the part. He has worked as a data manager in a secondary school in the UK and has years of experience in the classroom with Microsoft PowerPoint. He loves to encounter problems in Microsoft Office and use his expertise and legal-level training to find solutions. Outside of the Microsoft world, Tony is a keen dog owner and lover, football fan, astrophotographer, gardener, and golfer. Sign in to your How-To Geek account Add Us On follow Follow followed Followed Like Like Thread Log in Here is a fact-based summary of the story contents: Try something different: Show me the facts Explain it like I’m 5 Give me a lighthearted recap Spreadsheet formulas used to feel fragile. One wrong column number could throw off an entire report. But when I finally replaced VLOOKUP with XLOOKUP, Excel started feeling predictable, flexible, and surprisingly hard to break. Breaking down the syntax that finally made Excel logic click The anatomy of a modern lookup for