Excel Forum

Excel Magic Trick #174: Smartest Excel People In The World

See an incredible Excel Trick From Aladin at the Mr Excel Message Board. See how to lookup up the last value in an unsorted list. Learn about the LOOKUP function and how, like the SUMPRODUCT function, it does not require Ctrl + Shift + Enter to accommodate arrays.

Got a Question? Ask it Here in the Forum.