Forum Discussion
Solved
IF statement Formula not working
I'm trying to get a value in my category column with based on criteria in columns Y, Z, AC and AD. The value imp trying to in Category column is in Reference Table tab. I have tried to make a IFS s...
=INDEX('Reference Table'!$G$2:$G$34,MATCH(1,IFS([@Tier2]="Tier 1",('Reference Table'!$A$2:$A$34=[@Material])*('Reference Table'!$B$2:$B$34=[@Banding])*('Reference Table'!$E$2:$E$34=[@Tier2]),[@Tier2]="Tier 3",--('Reference Table'!$E$2:$E$34=[@Tier2]),[@Tier2]="Tier 2",('Reference Table'!$E$2:$E$34=[@Tier2])*('Reference Table'!$F$2:$F$34=[@Policy])),0))
=INDEX('Reference Table'!$G$2:$G$34,MATCH(1,IFS([@Tier2]="Tier 1",('Reference Table'!$A$2:$A$34=[@Material])*('Reference Table'!$B$2:$B$34=[@Banding])*('Reference Table'!$E$2:$E$34=[@Tier2]),[@Tier2]="Tier 3",--('Reference Table'!$E$2:$E$34=[@Tier2]),[@Tier2]="Tier 2",('Reference Table'!$E$2:$E$34=[@Tier2])*('Reference Table'!$F$2:$F$34=[@Policy])),0))
Brilliant Thank you Hans