Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Lookup Function-bottom to top

Rkumar
Rkumar ✭
edited 12/09/19 in Archived 2017 Posts

Is there anyway to use lookup function to find the match from bottom (most recent) of the table rather than finding the match from top?

· Share on FacebookShare on Twitter

Comments

  • Shaine Greenwood
    Shaine Greenwood Employee

    Hi Rkumar,

    LOOKUP is designed to work in sorted (return the first value less than or equal to the lookup value) or unsorted (returns an exact match for the lookup value) lookup tables. There isn't a way to force the function to look from bottom to top rather than top to bottom. 

    All of our functions that calculate over ranges work from top to bottom, left to right. There isn't a way to change this behavior. You'd need to apply a sort to your table such that moves the recent rows to the top of the table.

    · Share on FacebookShare on Twitter
  • Rkumar
    Rkumar ✭

    I understand, thank you!

    · Share on FacebookShare on Twitter
  • Diaz
    Diaz ✭

    There is a way to force bottom to top LOOKUP in Excel.  It doesn't seem to work in SmartSheets though.  This is what it looks like in Excel and perhaps what it may look like when possible in SmartSheets:

    LOOKUP(2,1/($A$2:$A$19=D2),$B$2:$B$19)

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories