Answer

said
5 months ago

Hi Matan,

Thanks for reaching out! I came up with a formula that I think will work on your desired output.

Syntax: **(lookup_formula).blank? ? "Value if Blank": (lookup_formula)**

This formula will get the value in the lookup table then if the value was not found on the lookup table, it will return the string "Value if Blank". Hence, it will just return the value found on the lookup table.

Hope this helps!

Let me know if you have further questions.

said
about 1 month ago

You could also just use an 'or' formula. It reads from left to right and takes the first value if first value is not null. Otherwise, it takes the second value.

Send us a ticket, we will try our best to assist you with your problem

## Matan Alon

## trying to write a complex formula - lookup

Hi,

I'm trying to write a formula that will try to find a value in a lookup table and if no value is found to use a default value.

I tried to combine a condition formula with a lookup but nothing really worked for me.

Thanks in advance!

Gibson Cabellosaid 5 months agoHi Matan,

Thanks for reaching out! I came up with a formula that I think will work on your desired output.

Syntax:

(lookup_formula).blank? ? "Value if Blank": (lookup_formula)This formula will get the value in the lookup table then if the value was not found on the lookup table, it will return the string "Value if Blank". Hence, it will just return the value found on the lookup table.

Hope this helps!

Let me know if you have further questions.