Hello, looking for help on how to to create a formula that references text in another “cell” on a different table to complete the formula.

Here’s what I’m looking to do:

Create an “IF(logical, value1, value2)” statement formula for a column in table 1 in a base, that references a single cell from table 2 (within the same base) that contains text to be included as a one of the values?

Can someone advise if this is possible, and if so, how to go about doing it?

Thanks,

Cristy