I am wondering if someone can help.
I have attached a sample spreadsheet.
Tab Example 1 is what I currently use but I am looking for a solution that will provided me with the results seen in Example 2.
Essentially I only want to enter the condition once in E9 (drop down list). The formula will look at the recommendation in F9 and auto populate this in E10 and so on.
I have entered =F9 into E10 and then dragged the formula down. The problem I am having is when it comes to my “exempt” condition.
If I have this entered I want a formula that is able to see the last recommended condition used and insert that instead.
In Example 2 the condition in E12 is exempt and in F12 the recommendation is exempt. I have then manually entered B into E13. As B was the last recommendation (F11)
Ideally I would like to keep my drop down menus but any solution would be great.
Thanks in advance,