Return a numerical value based on a Single Select Dropdown

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