BloomTech’s Downfall: A Long Time Coming

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel Basics - Excel VLOOKUP Function Made Easy

ExcelIsFun via YouTube

Start learning Write review

Overview

This course teaches learners how to effectively use the VLOOKUP function in Excel through nine practical examples. By the end of the course, students will be able to: - Understand when to use VLOOKUP over other functions like IF statements - Utilize VLOOKUP for both exact and approximate matches - Create dropdown lists for data validation - Retrieve specific information from lookup tables - Calculate values based on lookup results The course employs a hands-on approach, with step-by-step demonstrations of each example in Excel. It is designed for individuals looking to enhance their data analysis and manipulation skills using Excel, particularly those who work with large datasets or regularly perform data lookups and comparisons.

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

Reviews

Start your review of Excel Basics - Excel VLOOKUP Function Made Easy

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.