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

Excel Basics - Excel VLOOKUP Function Made Easy

ExcelIsFun via YouTube

Start learning Write review

Details

Start learning

Provider

YouTube
Pricing

Free Video
Languages

English
Effort

40 minutes
Sessions

Self-Paced
Level

Beginner

Found in

This beginner course teaches Excel’s VLOOKUP function through nine examples using exact and approximate matches. Learners retrieve product prices, commissions, employee information, salaries, taxes, and payroll amounts, including use of data-validation drop-down lists.

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.