I have asked a question similar to this before and got a pretty good yet confusing answer, however would not work in this exact case very well.
I am attaching an example of what I am looking for hoping you could make the change that I need.
I have a list of values that I set to range list 1. Beside list 1 I have another list of values list 2 that correspond to each adjacent value in list 1. Then i created a drop down list with those values from list 1. What i want to do is when someone selects a value from list 1 it displays the value from list 2 in another cell.
confused yet? If you look at the spreadsheet it should help. So if "granted" is selected from the dropdown list 1 then in C2 it will populate "this is what I want displayed if granted is selected"
please help this is very important. thank you. example.xlsx