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...
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...
Vlookup on Dates and Times in Excel
Tutorial: Perform a lookup on dates and times in Excel: vlookup, hlookup, index/match, any kind of l...

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.