Lookup Functions and Formulas in Excel 2016 - Comprehensive Lessons with 20 Examples

Lookup Functions and Formulas in Excel 2016 - Comprehensive Lessons with 20 Examples

ExcelIsFun via YouTube Direct link

) Introduction

1 of 23

1 of 23

) Introduction

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Lookup Functions and Formulas in Excel 2016 - Comprehensive Lessons with 20 Examples

Automatically move to the next video in the Classroom when playback concludes

  1. 1 ) Introduction
  2. 2 ) Data Validation List. VLOOKUP, Exact Match. IF & ISBLANK functions. Goal: Create Invoice.
  3. 3 ) HLOOKUP with Exact Match Lookup. Goal: Lookup Tyrone's Phone Number. Horizontal Lookup is rare.
  4. 4 ) VLOOKUP with Approximate Match Lookup. Goal: Lookup Pipe size.
  5. 5 ) VLOOKUP with Approximate Match Lookup. Goal: Lookup Commission Paid.
  6. 6 ) VLOOKUP with Approximate Match Lookup. Cell Reference for Column Index Number. Goal: Get Rating and Commission.
  7. 7 ) VLOOKUP and MATCH functions with Exact Match Lookup. MATCH for Column Index Number. Goal: Retrieve employee data.
  8. 8 ) VLOOKUP & ROWS or COLUMNS with Exact Match Lookup. ROWS or COLUMNS for Column Index Number. Goal: Retrieve record from Employee Table.
  9. 9 ) Multiple VLOOKUP functions. Goal: Calculate taxes from complex tax table.
  10. 10 ) How to use VLOOKUP, LEFT and SEARCH to do a "Partial Text Lookup. Goal: Lookup Product Price.
  11. 11 )Also: Look at Data Mismatch in lookup formulas.
  12. 12 ) INDEX and MATCH functions to do a "Lookup Left". INDEX array argument is a column. Goal: Given a flight range, lookup boomerang name in first column.
  13. 13 ) INDEX and MATCH to find Vendor for Low Bid. INDEX array argument is a row. Goal: lookup vendor name for lowest bid.
  14. 14 ) INDEX and MATCH functions to do a Two-Way Lookup. INDEX array argument is a table. Goal: Do Two-Way Lookup to find Discount.
  15. 15 ) INDEX and MATCH to lookup a whole column or row. INDEX array argument is a table. Goal: Lookup: 1) whole column of values then 2) whole row of values.
  16. 16 ) How to use VLOOKUP & CHOOSE to do a lookup to multiple tables. Goal: Lookup Commission rate from Multiple Lookup tables.
  17. 17 ) LOOKUP function with lookup_value and array arguments. Approximate Match. Goal: Lookup Commission and Rating. LOOKUP to enter fewer arguments.
  18. 18 ) LOOKUP with lookup_value and lookup_vector and result_vector arguments. Approximate Match. Goal: Lookup Last Date and find site. LOOKUP to do Array Operation.
  19. 19 ) LOOKUP with lookup_value and lookup_vector and result_vector arguments. Approximate Match. Goal: "Lookup Adding" to total costs. LOOKUP to do Array Operation.
  20. 20 ) INDEX and ROWS to Flip Grade Table. Goal: Flip a Grade Table.
  21. 21 ) Use MATCH to Compare Two Lists. Goal: Is an item in List 1 also in List 2?
  22. 22 ) Use MATCH to Compare Two Lists. Goal: Is an item in List 1 NOT in List 2?
  23. 23 ) Summary

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.