Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.
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
ExcelIsFun
Get personalized course recommendations, track subjects and courses with reminders, and more.
