I am trying to create a spreadsheet for RPG world building, settlement creation to be specific, and would like to create a nested if statement that references a drop down selection.
Example: =IF([droplist=thorp],C3,(IF([droplist=hamlet],C4)))
The text in brackets is for a lack of knowing how to create the formula properly if it can even be done.
There are many applications in just this one document that this would solve for me if anyone has the solution.