Completed
2. Table taller or equal to width, does vertical lookup min
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
LOOKUP Function Beginner to Advanced 23 Examples - Excel VLOOKUP WEEK Video
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Approximate Match only min
- 2 2. Table taller or equal to width, does vertical lookup min
- 3 3. Table wider than tall, does horizontal lookup min
- 4 4. Always takes last value from last column min
- 5 5. If you sort your column you can trick it into doing Exact Match min
- 6 6. Has lookup range argument and a separate range with values you would like to retrieve values from: Retrieve Records min
- 7 7. Exactly same rows and columns, LOOKUP does Vertical lookup: min
- 8 8. LOOKUP as easier substitute for VLOOKUP min
- 9 9. Lookup Adding min
- 10 10. Lookup Adding with Criteria, with array in lookup value argument min
- 11 11. LOOKUP can handle arrays when delivering a single value, and will not require Ctrl + Shift + Enter min
- 12 12. LOOKUP Left with two criteria min
- 13 13. Lookup Last Value min
- 14 14. Lookup Last Text String Including Blanks From Formulas min
- 15 15. Lookup Last Text String Excluding Blanks From Formulas min
- 16 16. Lookup Last Item Text or Number min
- 17 17. Last Value From Specified Row min
- 18 18. Last Trade Entered On Specific Date min
- 19 19. Lookup multiple sub-text-strings within text string and return a code min
- 20 20. Find word in text string and extract it, otherwsie Blank min
- 21 21. Commission Paid: 3 LOOKUPS in one formula min
- 22 22. Finance Payback Rule min
- 23 23. Conditional Formatting min
