Completed
min) VLOOKUP for Sales Type for large data set with lookup table on different Sheet, 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.
