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: