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

Help with formula
I am currently using this formula and it works just fine. =IF(AND([90 Day Window 3]@row = "Ready", [60 Day Window 2]@row = "Ready", [30 Day Window 1]@row = "Ready"), "Ready", "Not Ready") But I am trying to add another part to it that has 2 things to referance to make true but does not work and Im sure its becuase or the…
Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Determining the # of days formula
Im trying to calculate the number of days for a project based on the budget dollars $14,256.90 with an average of $30.00 per hour per employee for 4 employees (resources) and 8 hours per day