Excel Forum

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.