LOOKUP Function Beginner to Advanced 23 Examples - Excel VLOOKUP WEEK Video

Overview

Explore 23 comprehensive examples of the Excel LOOKUP function in this 46-minute video tutorial, ranging from beginner to advanced levels. Learn how to perform vertical and horizontal lookups, handle approximate and exact matches, retrieve records, work with arrays, and apply LOOKUP in various scenarios such as adding with criteria, finding last values, extracting text strings, and implementing financial rules. Master techniques for combining multiple LOOKUP functions in a single formula and apply conditional formatting. Download accompanying workbooks to practice alongside the instructor and enhance your Excel skills through hands-on examples.

Syllabus

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