Forum Discussion
IFS Formula help
Hi, Im trying to write a IFS formula With the attached file. In column AP I'm trying to get the relevant category for that cell from my "reference table" column G. I want to use the criteria for c...
On Sheet1, all rows with Non-Policy have Tier1. But there is no row for Non-Policy and Tier1 on the Reference Table sheet. What gives?
Hi
That is because Tier 1 and Tier 3 are not effected by Policy/Non Policy
meaning i dont want to show categories for Tier 1 thats dictated by Policy/non policy criteria
That is because Tier 1 and Tier 3 are not effected by Policy/Non Policy
meaning i dont want to show categories for Tier 1 thats dictated by Policy/non policy criteria