Help with formula looking up values from 2 columns

What formula would you use to lookup a value in column 1, if no value, use value in column 2?

I have a new column “User Company Name” that I want to pull the value from either “Customer Name” or “CM Name”. I tried this formula- IF({Customer Name}, {CM Name}) with no luck.

You will see one column is linked, the other a lookup. Any help would be greatly appreciated. The names used in tables are fictional, examples only.

Hey @airtablewhitebelt!


IF(Customer Name, Customer Name, CM Name)

This says IF Customer Name, use Customer Name, otherwise use CM Name


That works. Thank you for your help! Much appreciated!

1 Like

You bet! Glad it worked for you.