I hope someone can help with this question as I have to believe there is a way or better approach like using an index or array in the formula but I've never done that.
In the spreadsheet below, I am trying to evaluate the following in the formula in column "A".
If column B=Enhancement and if...