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
ββ
Hi Team, In regards to the LOOKUP() function can the lookup_value be a cell reference instead of a "text" search?
Comments
-
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.
-
Awesome, thanks Shaine!
This discussion has been closed.