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 return value
Hi Smartsheet team,
Thanks for getting the much awaited LOOKUP function supported in Smartsheet.. This is a great add !!
I see a problem with LOOKUP() return value when the lookup_value is not found in lookup_range. It is returning Empty string instead of an Error.
Because of this, I am not able to distinguish between key not found and empty index column value. This is a big limitation to LOOKUP function as of now.
I hope this issue will be fixed soon.
Note: Excel returns #NA Error when lookup value is not found in the lookup range.