Excel - Using Excel's XLOOKUP Function

4.0 (5)

37 learners

What you'll learn

This course includes

39.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

xlookup ms xlookup ms excel xlookup excel xlookup vlookup using xlookup using excel xlookup using xlookup in excel hlookup how to use xlookup how to use xlookup in excel exel xlookup

Full Transcript

Learn how to use the fairly new and fantastic XLOOKUP function in Microsoft Excel. XLOOKUP replaces the VLOOKUP and HLOOKUP functions and can help you quickly search a huge spreadsheet based upon information you have and it will find and return information that you're looking for. This is a powerful function that will become more and more important as it effectively replaces the older lookup functions. Watch my entire playlist of Excel tutorials: http://bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents Here's the practice file for this video (copy/paste it into browser): http://bit.ly/excelxlookup #exceltutorial #excel #xlookup

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Welcome