Learn how to use Excel’s most powerful lookup functions — VLOOKUP, HLOOKUP, and XLOOKUP — in this easy-to-follow tutorial. Whether you're working with legacy Excel models or building new dashboards from scratch, understanding lookup formulas is essential. In this video, we’ll cover: • What lookup functions are and where they’re used • How to use VLOOKUP and HLOOKUP (legacy formulas) • Why XLOOKUP is a better modern alternative • How to perform lookups using multiple keys • Best practices like error handling for cleaner spreadsheets Whether you’re a beginner or brushing up on Excel skills for work or school, this tutorial will help you get confident with lookups. Chapters 00:00 – Intro 00:30 – What are lookup functions 01:12 – Vlookup 04:29 – Hlookup 06:00 – Xlookup 07:10 – vlookup vs xlookup 09:42 – lookup with multiple values 12:26 – Error Handling 15:00 – Wrap up Download Practice Files: Check out blog post for this tutorial: 👍 Like the video if you find it helpful, and subscribe for more tutorials on Excel, Power BI, and data analytics! #Excel #XLOOKUP #VLOOKUP #ExcelTips #ExcelTutorial #SpreadsheetSkills Social: IG: FB: LinkedIn: X: Other interesting videos: Power Query: Excel:











