Play all

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

Description:

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.

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

ExcelIsFun

Add to list

#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Manipulation

0:00 / 0:00