Formula IF statement pulls data from a specific row + cell

[Cassy_Amelia]

Hi,

Not sure if this is possible...

I'm looking to create a formula that checks the condition of a single select cell called {Alt Shop}. IF empty use {Discount Code} if it contains "Shop Name" to use data from a particular cell in a particular row.

For example {Alt Shop} contains "GAP", use data from cell named {Discount Code} on row named "GAP".

Thank you for your help 🙂 

[TheTimeSavingCo]

Hmm, if I were you I would:

1. Create another table where each record represents a shop with their discount code called "Shops"
2. In the original table, create a linked field to "Shops"
3. In the original table, create a lookup field from the linked field from the previous step displaying the value from the field "Discount Code" from the "Shops" table
4. In the original table, create a formula field with an "IF()", that will display the value from the lookup field from step 3 if a "Shops" record is linked, and if not, display the value from the "Discount Code" field from the original table