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