Forum Discussion
IF statement Formula not working
=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))
What if I added a column for pressure in the Reference Table to have a criteria for pressure i have added rows for whichever row shows as "MP" in Pressure column.
How would I extend the formula to include this statement and have the new categories showing for MP?
You complicated it unnecessarily by changing the tiers to T1, T2 and T3 in the reference table but not on the master sheet.
And in the reference table, you have 4"-5" but on the master sheet it is 4-5", etc.
This is not workable. Please make the two sheets consistent, then post again.
- Brilliant Thank you Hans