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

Cannot Edit formula?
I had my recruiter create a SmartSheet that we want to use to calculate starting pay for new hires. She has a few formula columns designed to assess the weight of a candidate's experience but she's running into issues/errors with some of them and I'd like to help. She's made me an Admin on this sheet but I am unable to…
Cell Linking
Can you do cell linking within the same sheet?
Froms Font
Can I change the size of the font in a form? The description font is very small. And how do I change the color / size of the link…it's there in blue but I want to make it white. I tried using the edit option to the right but it's not changing.