Formula that returns a value if the row contains a specific option
I could really use some help with creating a formula that will give me a specific output based on a dropdown selection.
I have a column where a county can be selected, and based on the selection, I would like a different column to display a number. The thought process would be if Column County contains A, B, C, or D, display 1 in Column County Number, or if Column County contains E, F, G, or H, display 2 in Column County Number.
Is there any way to accomplish this? I have been looking online, and I cannot find a statement that matches what I am looking for. I would need to group together several counties that can return a value between 1 to 14. Any help to accomplish this would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!