- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 19, 2025 09:00 AM - edited ‎Feb 19, 2025 09:00 AM
Hi there. I'm trying to create a formula that returns a numerical value (price) based on a dropdown field. So, if "Option Zebra" is selected in the dropdown, the formula returns a value of 250. If "Option Lion", then the formula returns a value of 300, etc. Would some amazing wizkid be able to help me with that?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 19, 2025 09:07 AM - edited ‎Feb 19, 2025 09:07 AM
If you only have a few items in your single-select field, you could do that with a SWITCH formula:
SWITCH(
{Your Single Select Field Here},
"Option Zebra", 250,
"Option Lion", 300
)
However, if you're going to have more than a few options, your best bet is to create a new table of products, where you would create fields for the product name and the price.
Then, back in your original table, you would create a linked record field that links to the table of products. Then, you would create a lookup field that looks up the price from the table of products.
I discuss linked record fields and lookup fields more in depth in my free Airtable training course, which you can take for free by signing up for a free 30-day trial with LinkedIn Learning. Note that this course is many years outdated at this point, but the key concepts of linked record fields and lookup fields still apply.
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 19, 2025 09:07 AM - edited ‎Feb 19, 2025 09:07 AM
If you only have a few items in your single-select field, you could do that with a SWITCH formula:
SWITCH(
{Your Single Select Field Here},
"Option Zebra", 250,
"Option Lion", 300
)
However, if you're going to have more than a few options, your best bet is to create a new table of products, where you would create fields for the product name and the price.
Then, back in your original table, you would create a linked record field that links to the table of products. Then, you would create a lookup field that looks up the price from the table of products.
I discuss linked record fields and lookup fields more in depth in my free Airtable training course, which you can take for free by signing up for a free 30-day trial with LinkedIn Learning. Note that this course is many years outdated at this point, but the key concepts of linked record fields and lookup fields still apply.
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 19, 2025 09:11 AM
That's awesome Scott, thanks so much for the amazingly prompt reply! For this scenario the SWITCH option works really well!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 19, 2025 09:12 AM
You're welcome! Glad I could help! 😀
