How do i write a formula to populate say b1 with a particular value if a1 has a particular text from a drop down list? My drop down list in a1 would be
Each one has a corresponding value (listed below in order)
How would I create a formula that would populate b1 with the value that corresponds to the choice from the drop down list?
Thanks in advance