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.

Problems with LOOKUP formula

09/29/16 Edited 12/09/19

Hello,

 

I'm encountering an issue with the LOOKUP formula in Smartsheet.

Apparently it doesn't work with the names that I use in my lookup range (note that I dragged the formula down to the bottom, using "$" to block the rows of the range, but I get no results):

 

I would like to understand why it is not working and if there is a simple way to solve this.

 

Thank you,

 

Edward

 

smartsheet lookup.png

smartsheet lookup.png

Comments

  • Hello Edward,

     

    LOOKUP by default will look through the table for the closest match. Since your table isn't sorted in alpha-numeric order it will stop at the first row because its value starts with "z". You'd either need to sort the table or set your LOOKUP formula to keep looking through the table for an exact match. To do this, add a "false" argument at the end. 

     

    =LOOKUP([Column 3]1, [Column 1]$1:[Column 2]$14, 2, false)

     

    Refer to this Community post for more information on this: https://community.smartsheet.com/discussion/lookup-function-return-value or let me know if you have any issues with this. 

This discussion has been closed.