Completed
min) VLOOKUP for Sales Category, approximate match.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
IF or VLOOKUP Function for Assigning Categories with Excel Formula - 8 Examples
Automatically move to the next video in the Classroom when playback concludes
- 1 min) Overview
- 2 min) IF and Hard Coded Values: Violates Excel's Golden Rule, but it you may not want table on sheet. Assigning Race Categories to Race Times. ISBLANK function.
- 3 min) IF and Cell References: Allows you to change Formula Inputs and formulas will update. Assigning Race Categories to Race Times.
- 4 min) VLOOKUP: Easier than multiple IFs. First column sorted small to big, column_index = which column has value you want to return to cell, approximate match is default. Assigning Race Categories to…
- 5 min) VLOOKUP for Sales Category, approximate match.
- 6 min) VLOOKUP, Exact match. Assigning Categories to Products.
- 7 min) VLOOKUP with table hard coded into formula, so you don't have to have table on sheet. F9 = Evaluation key = creates hard coded array.
- 8 min) VLOOKUP for Product Category for large data set with lookup table on different Sheet, Exact Match.
- 9 min) VLOOKUP for Sales Type for large data set with lookup table on different Sheet, Approximate Match.
