How to use VLOOKUP in Excel - Complete Tutorial
In this step-by-step tutorial, learn how to use VLOOKUP, HLOOKUP, AND XLOOKUP in Microsoft Excel. With VLOOKUP, you can find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.
👋 Additional resources:
- Sample file to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whK4bPgcKpfbw0Iub5A?e=1NQpEF
⌚ Timestamps
0:00 Introduction
1:47 Organize data properly for VLOOKUP
5:38 VLOOKUP Exact match
9:34 Improve error message with IFERROR
11:10 VLOOKUP Closest match
14:48 VLOOKUP Across sheets
15:43 HLOOKUP
18:21 XLOOKUP Simple example
22:53 XLOOKUP Combined with other functions
24:54 XLOOKUP Returns an array
26:42 XLOOKUP Match modes
28:30 XLOOKUP Search modes
31:24 Wrap up
📃 Watch related playlists and videos
- Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
🚩 Connect with me on social:
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert
Видео How to use VLOOKUP in Excel - Complete Tutorial канала Kevin Stratvert
👋 Additional resources:
- Sample file to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whK4bPgcKpfbw0Iub5A?e=1NQpEF
⌚ Timestamps
0:00 Introduction
1:47 Organize data properly for VLOOKUP
5:38 VLOOKUP Exact match
9:34 Improve error message with IFERROR
11:10 VLOOKUP Closest match
14:48 VLOOKUP Across sheets
15:43 HLOOKUP
18:21 XLOOKUP Simple example
22:53 XLOOKUP Combined with other functions
24:54 XLOOKUP Returns an array
26:42 XLOOKUP Match modes
28:30 XLOOKUP Search modes
31:24 Wrap up
📃 Watch related playlists and videos
- Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
🚩 Connect with me on social:
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert
Видео How to use VLOOKUP in Excel - Complete Tutorial канала Kevin Stratvert
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to use Power Pivot in Microsoft Excel7 Ways to Use Vlookup in ExcelVlookup simply explainedMicrosoft Excel Tutorial for Beginners - Full CourseTop 20 Microsoft Outlook Tips & TricksVLOOKUP EXPLAINED - 2 Practical Excel Lookup ExamplesData cleaning in Excel - 10 tricks *PROs* use all the timeHow to use COUNTIF and COUNTIFS in Microsoft ExcelMicrosoft Excel Tutorial: 3-Hour MS Excel 2019 Course for Beginners!Compare Two Lists Using the VLOOKUP FormulaHow to use Microsoft Access - Beginner TutorialHow to use Microsoft Power BIWhen Should you Use the Hash Sign (#) in Excel Formulas?How to Create Macros in Excel TutorialTop 20 Microsoft Excel Tips & TricksExcel VLOOKUP With Multiple WorkbooksExcel 2016 AdvancedTop 50 Microsoft Excel Shortcut KeysIntroduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)Excel Features You NEED to KNOW (If you work in Accounting)