Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Lookup + Single Select Formula

Topic Labels: Formulas
420 1
Showing results for 
Search instead for 
Did you mean: 

I would like to do a lookup based on what is selected in a Single Select field.

For example:
IF single select field is A, Lookup Record X
IF single select field is B, Lookup Record Y

How can this be set up to avoid errors?

1 Reply 1

Lookups are based on Linked Record fields. So you would need to choose either Record X or Record Y in your linked record field.