VLOOKUP Tutorial for Excel - Everything You Need To Know
In this video I explain everything you need to know to get started with VLOOKUP for Excel. Download the Excel file: https://www.excelcampus.com/filedownload/VLOOKUP-Practice-File.xlsx
This tutorial is a follow-along lesson where you will learn to write Vlookup formulas as you watch the video.
It's great for beginners. However, the video is packed with additional tips and tricks for writing formulas that will help save anyone time when writing formulas.
Here are the major topics covered:
00:00 1. What does Vlookup function do and how does it work?
03:26 2. How to write a simple Vlookup formula?
07:54 3. The two main causes of errors with Vlookup.
12:53 4. Vlookup stops at the first match & the sorting myth.
15:07 5. How to create relationships between tables & ranges.
15:55 6. Vlookup to other sheets.
One thing I forgot to mention in the video is the F4 equivalent keyboard shortcut on the Mac version of Excel is Cmd+T. This is for toggling the absolute and relative references when writing the formula.
At the end of the video I mention a bonus challenge (https://excelcampus.com/vlookup-challenge) that will help you practice and learn additional techniques with Vlookup. This includes:
- The IFERROR function for handling errors.
- Dynamic Vlookup formulas for adding and deleting columns.
- Adding drop-down lists to create interactive spreadsheets.
- Conditional formatting to highlight rows based on a matching value.
- Vlookup with Excel Tables and Structured Reference Formulas.
Please click the link below to download the challenge file and get access to the solution videos. It's free!
👉https://excelcampus.com/vlookup-challenge
Additional Resources:
Beginner's Guide to Excel Tables: https://youtu.be/fJnJTff4Na8
Video Series on Pivot Tables & Dashboards: https://youtu.be/9NUjHBNWe9M
COUNTIF instead of VLOOKUP: https://youtu.be/ua6qo5gaZ9M
For more tips please subscribe to our free weekly email newsletter:
https://excelcampus.com/free
#MsExcel #ExcelCampus
Видео VLOOKUP Tutorial for Excel - Everything You Need To Know канала Excel Campus - Jon
This tutorial is a follow-along lesson where you will learn to write Vlookup formulas as you watch the video.
It's great for beginners. However, the video is packed with additional tips and tricks for writing formulas that will help save anyone time when writing formulas.
Here are the major topics covered:
00:00 1. What does Vlookup function do and how does it work?
03:26 2. How to write a simple Vlookup formula?
07:54 3. The two main causes of errors with Vlookup.
12:53 4. Vlookup stops at the first match & the sorting myth.
15:07 5. How to create relationships between tables & ranges.
15:55 6. Vlookup to other sheets.
One thing I forgot to mention in the video is the F4 equivalent keyboard shortcut on the Mac version of Excel is Cmd+T. This is for toggling the absolute and relative references when writing the formula.
At the end of the video I mention a bonus challenge (https://excelcampus.com/vlookup-challenge) that will help you practice and learn additional techniques with Vlookup. This includes:
- The IFERROR function for handling errors.
- Dynamic Vlookup formulas for adding and deleting columns.
- Adding drop-down lists to create interactive spreadsheets.
- Conditional formatting to highlight rows based on a matching value.
- Vlookup with Excel Tables and Structured Reference Formulas.
Please click the link below to download the challenge file and get access to the solution videos. It's free!
👉https://excelcampus.com/vlookup-challenge
Additional Resources:
Beginner's Guide to Excel Tables: https://youtu.be/fJnJTff4Na8
Video Series on Pivot Tables & Dashboards: https://youtu.be/9NUjHBNWe9M
COUNTIF instead of VLOOKUP: https://youtu.be/ua6qo5gaZ9M
For more tips please subscribe to our free weekly email newsletter:
https://excelcampus.com/free
#MsExcel #ExcelCampus
Видео VLOOKUP Tutorial for Excel - Everything You Need To Know канала Excel Campus - Jon
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
INDEX MATCH Explained (An Alternative to VLOOKUP)How to use VLOOKUP in Excel - Complete TutorialVlookup simply explained50 Ultimate Excel Tips and Tricks for 2020Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)How to Create Drop Down Lists in Cells - The Complete Excel GuideAdvanced Excel - VLOOKUP BasicsAdvanced Excel - Creating Pivot Tables in ExcelExcel for Accounting - 10 Excel Functions You NEED to KNOW!A Real-Life Excel Test from a Job Interview: Can You Pass??Learn Vlookups in 7 Minutes (Microsoft Excel)Compare Two Lists Using the VLOOKUP FormulaExcel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)Top 10 Most Important Excel Formulas - Made Easy!The New XLOOKUP Function: Compared to VLOOKUP & INDEX MATCH in ExcelMicrosoft Excel Tutorial for Beginners - Full CourseExcel VLOOKUP With Multiple WorkbooksMS Excel - Vlookup in Excel Video Tutorials