Completed
) Introduction
Class Central Classrooms beta
YouTube playlists 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 ) Introduction
- 2 ) Data Validation List. VLOOKUP, Exact Match. IF & ISBLANK functions. Goal: Create Invoice.
- 3 ) HLOOKUP with Exact Match Lookup. Goal: Lookup Tyrone's Phone Number. Horizontal Lookup is rare.
- 4 ) VLOOKUP with Approximate Match Lookup. Goal: Lookup Pipe size.
- 5 ) VLOOKUP with Approximate Match Lookup. Goal: Lookup Commission Paid.
- 6 ) VLOOKUP with Approximate Match Lookup. Cell Reference for Column Index Number. Goal: Get Rating and Commission.
- 7 ) VLOOKUP and MATCH functions with Exact Match Lookup. MATCH for Column Index Number. Goal: Retrieve employee data.
- 8 ) VLOOKUP & ROWS or COLUMNS with Exact Match Lookup. ROWS or COLUMNS for Column Index Number. Goal: Retrieve record from Employee Table.
- 9 ) Multiple VLOOKUP functions. Goal: Calculate taxes from complex tax table.
- 10 ) How to use VLOOKUP, LEFT and SEARCH to do a "Partial Text Lookup. Goal: Lookup Product Price.
- 11 )Also: Look at Data Mismatch in lookup formulas.
- 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 ) INDEX and MATCH to find Vendor for Low Bid. INDEX array argument is a row. Goal: lookup vendor name for lowest bid.
- 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 ) 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 ) How to use VLOOKUP & CHOOSE to do a lookup to multiple tables. Goal: Lookup Commission rate from Multiple Lookup tables.
- 17 ) LOOKUP function with lookup_value and array arguments. Approximate Match. Goal: Lookup Commission and Rating. LOOKUP to enter fewer arguments.
- 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 ) 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 ) INDEX and ROWS to Flip Grade Table. Goal: Flip a Grade Table.
- 21 ) Use MATCH to Compare Two Lists. Goal: Is an item in List 1 also in List 2?
- 22 ) Use MATCH to Compare Two Lists. Goal: Is an item in List 1 NOT in List 2?
- 23 ) Summary
