Back to Browse

Excel XLOOKUP Tutorial | NEVER use VLOOKUP again | Data Analyst Skill Tutorial #4

16.7K views
Nov 2, 2022
10:12

This video introduces XLOOKUP in Excel. For my sanity, let's all band together and kill VLOOKUP once and for all. Link to the Excel file I used for this tutorial (without the edits I made in the video): https://github.com/alexsington/Data-Sets/blob/main/XLOOKUP%20tutorial%20(original).xlsx Intro rant: 00:00 Tradition example #1: 1:14 Tradition example #2: 3:43 Inexact matches: 5:05 Alternative to INDEX-MATCH: 7:22 Contact me: [email protected] https://www.linkedin.com/in/alex-sington-b7751a181/

Download

1 formats

Video Formats

360pmp415.3 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Excel XLOOKUP Tutorial | NEVER use VLOOKUP again | Data Analyst Skill Tutorial #4 | NatokHD