Excel Forum
Similar Content
Determine if Cells Contain a Specific Value in Excel
Tutorial: Find if a cell or range of cells contains a specific value in Excel. This method can be us...
Simple Excel Function to Extract a Word or Text from a Cell
Tutorial: Excel function that makes it easy to extract a word or text from a cell in Excel. This is ...
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 454: Get Last Number or Word or Anything 4 Amazing LOOKUP functions


See 4 formulas using LOOKUP function to look up last number, or last word, or last items no matter if it is a word or number. Learn about the important numbers:
1)9.99999999999999E+307 is the biggest number that Excel can understand Big Num
2)255 is the max number of characters that lookup_value can be
3)2 is bigger than all the 1s generated from a list of TRUEs.





Got a Question? Ask it Here in the Forum.