YoVDO

Excel Basics - Excel VLOOKUP Function Made Easy

Offered By: ExcelIsFun via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses Data Manipulation Courses Data Validation Courses VLOOKUP Function Courses

Course Description

Overview

Master the powerful VLOOKUP function in Excel with this comprehensive 40-minute video tutorial. Learn when to use VLOOKUP instead of IF, understand the function's core purpose, and explore various lookup table examples. Discover the meaning behind the "V" in VLOOKUP and dive into nine practical examples, including exact and approximate match scenarios. Practice creating data validation dropdown lists, calculating bonus commissions, retrieving employee information, determining tax amounts, and more. Download accompanying Excel files and written notes to follow along and reinforce your learning. By the end of this tutorial, you'll be equipped to leverage VLOOKUP for efficient data retrieval and analysis in your Excel projects.

Syllabus

) Introduction.
) Should we use IF or VLOOKUP?.
) What does VLOOKUP do?.
) Examples of Lookup Tables.
) What does “V” in VLOOKUP mean?.
) Formula 1: Exact Match VLOOKUP to get Product Price & Data Validation Dropdown List: =VLOOKUP(E23,A23:C27,3,0).
) VLOOKUP can do 2 different tyoes of Lookup.
) Formula 2: Exact Match VLOOKUP to get Product Price for an Invoice: =VLOOKUP(A41,$A$23:$C$27,3,0).
) Add Data Validation List to a cell to create a drop-down list of valid lookup values for VLOOKUP Function.
) Formula 3: Approximate Match VLOOKUP to get a Bonus Commission %: =VLOOKUP(B21,$F$21:$G$27,2).
) Formula 4: Approximate Match VLOOKUP to get a Bonus Commission % & Calculate Bonus Amount: =VLOOKUP(B33,$F$21:$G$27,2)*B33.
) What VLOOKUP Does: Puts 1 of multiple things into a cell or formula..
) Formula 5: Exact Match VLOOKUP to get Employee E-mail and Phone Number: =VLOOKUP(A16,A2:I11,6,0).
) Formula 6: Exact Match VLOOKUP to List of Employee Salaries: =VLOOKUP(A23,$A$2:$I$11,9,0).
) Formula 7: Approximate Match VLOOKUP to get Tax Amount: =VLOOKUP(D4,A4:B8,2).
) Formula 8: Approximate Match VLOOKUP to get Commission Amount for Payroll Table: =VLOOKUP(E13,$A$13:$B$17,2).
) Formula 9: Approximate Match VLOOKUP to get Commission Amount for Payroll Table: =VLOOKUP(E4,$H$4:$I$9,2).
) Summary - Conclusion.


Taught by

ExcelIsFun

Related Courses

أفضل الممارسات لبرمجة وتطوير الهواتف المحمولة باستخدام جافا
Coursera Project Network via Coursera
Automate Validation using the Data Validation Tool (DVT)
Google via Google Cloud Skills Boost
AWS ML Engineer Associate 1.2 Transform Data (Korean)
Amazon Web Services via AWS Skill Builder
AWS ML Engineer Associate 1.3 Validação e preparação de dados para modelagem (Português) | AWS ML Engineer Associate 1.3 Validate Data and Prepare for Modeling (Portuguese)
Amazon Web Services via AWS Skill Builder
AWS ML Engineer Associate 1.3 Validate Data and Prepare for Modeling
Amazon Web Services via AWS Skill Builder