Hi,

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,

Boycie92