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

Mark Milham

Mark Milham ✭

09/28/16 edited 12/09/19 in Archived 2016 Posts

Hi Team, In regards to the LOOKUP() function can the lookup_value be a cell reference instead of a "text" search?

0 ·

Comments

Shaine Greenwood Employee

09/29/16

Hi Mark,

It sure can, an example as follows from testing this on my sheet:

=LOOKUP(Lookup6, Items1:[Part Number]4, 2)

When entering a value in the "Lookup6" cell, it returns the corresponding value from my lookup table.

0 · Share on Facebook Share on Twitter
Mark Milham ✭

09/30/16 edited 09/30/16

Awesome, thanks Shaine!

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Using Nested If and Formula to Set Value of Field
I'm trying to set the value of a field using an IF statement based upon a calculated number in a column called "Tier Score". =IF ([Tier Score]@row <= 17, "Tier 3", IF ([Tier Score]@row <= 25, "Tier 2", IF ([Tier Score]@row >= 26, "Tier 1"))) I keep getting UNPARSABLE. Thanks
Add to INDEX formula to account for blank cells?
I have a mapped column that displays a Contact based on what's inputted in another cell. E.g. Slim J = Slim Julian. Here's the formula: =INDEX({PD - NetSuite Name Mapping USE Range 1}, MATCH([PDS Selected]@row, {Formstack Name}, 0)) However, if the cell is blank, it just assigns the first Contact alphabetically, even…
Template with Dynamic view and Control Center
One of our templates relies on dyanmic view. Will the settings for Dynamic View stay in place when new project is created? All projects are created using Control Center. I've already searched in the Community, looked a articles, and learning.