Highline Excel 2013 Class Video 18

VLOOKUP Function 20 Examples, VLOOKUP Formula, Excel VLOOKUP

TOPICS IN THIS VIDEO

  • (00:38) Why do we have to know lookup functions? 
    (03:44) VLOOKUP, Exact Match. VLOOKUP delivers a value to the cell.
    (08:34) What happens if lookup value is not in your table? 
    (08:57) What happens if there are duplicates in first column of lookup table? 
    (10:38) VLOOKUP and IFERROR functions.
    (12:22) VLOOKUP ISNA and IF functions solution for Excel 2003 or earlier.
    (13:19) VLOOKUP and IFNA functions.
    (14:37) VLOOKUP and Data Validation List.
    (17:23) VLOOKUP with Named Range.
    (18:46) VLOOKUP as Formula Element.
    (19:42) The F2 Key for toggling between the 3 Formula Edit Modes: Edit, Enter, Point.
    Edit = Arrow Keys move through formula
    Enter = Arrow Keys can put cell references in formula
    Point = Arrow Keys are putting cell references in formula (dancing ants are dancing).
    (20:48) (Formula Evaluator (Evaluate Formula) to see VLOOKUP in Action.
    (21:30) Creating an Invoice: Data Validation List, VLOOKUP & IFNA, ROUND & IFERROR.
    (26:33) HLOOKUP function.
    (27:36) The Hows and Whys of Approximate Match Compared to Exact Match.
    (30:13) VLOOKUP, Approximate Match: Commissions Example.
    (33:10) VLOOKUP, Approximate Match: Grading Example.
    (35:05) DO NOT GET TRICKED BY NUMBER FORMATTING!!!! VLOOKUP and Percentages!!
    (36:23) VLOOKUP, Approximate Match: Tax Example.
    (40:31) Challenge for you!!! 
    For answer to challenge see 01:00:18 minute mark of this video: