Excel - Formulas & Functions: Part B - IF, VLOOKUP, IFERROR, Data Validation, Named Ranges
Channel: Valerie Webber
Date: 20/04/2021

0:00 If Basics sheet
17:29 IF Amount to Be Paid sheet
31:52 IF nested sheet - with Vlookup
39:51 VLOOKUP Bonus sheet (similar to ch 2 midlevel exercise)
48:33 VLOOKUP  Customer List sheet - with IFERROR
56:40 VLOOKUP  Invoice sheet - with IF, Data Validation, Named Ranges
1:08:57 VLOOKUP  Culminating sheet