I have a dropdown list with 16 possible things to chose from the list. I want to give a separate cell a value based on which thing the user choses from the list. I thought about using a Nested If function, but it only works with 7 or less.
I need something like this
If they chose "I am rich" from the dropdown list make the cell entitled net value= $300,000
etc