Hi, I have an index and match formula that works in some places and not others. I tried to attach a screen show that shows what I am trying to do along with this description. My formula in the Time an…
I am trying to rank a set of projects by tier 1-3 based on a scorecard. If scores come in between 0-11, tier 3, 12-19, tier 2 and above 20 tier 1. I am trying to use an IF(OR type of formula and keep …