I have a drop down menu with 10 different text options. These options represent different statuses on a project. (i.e.: Not started, Information Gathering, Speaking with Contacts, Development...)
I have, in another sheet, numerical percentages associated with these options. For example, Not Started would be 0%, Information Gathering would be 10%, etc. I would then take the numerical value and pass all them to another sheet where I represent this data in a graph.
How would I be able to query a specific cell against a set of option and populate another cell with a value based off the option selected. I believe it would be using multiple if statements, but I'm not sure.
Here's a diagram for what I'm looking to do: