Converting text to number

Sidonia Posteuca

I have a dropdown column with categories that I want to convert to numbers in another column.

For example, if the value in the dropdown column is "REPORT", then I want the other column to be the number "12". If the value in the dropdown column is "GO BACK", then I want the other column to be the number "5", etc.

I have three values in the dropdown column that I can select from. Based on what value I choose, I then need a formula to convert each value to a number in the subsequent column.

What formula(s) can I use to do this?

Paul H

Nested IF

=IF(Dropdown@row = "REPORT", 12, IF(Dropdown@row = "GO BACK", 5, IF(Dropdown@row = "THIRD OPTION", 2)))