Completed
1. Approximate Match only min
Class Central Classrooms beta
YouTube playlists 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