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...
=IFS([@Tier4]='Reference Table'!$E$44,'Reference Table'!$G$44,
AND([@Tier4]='Reference Table'!$E$42,[@Policy]='Reference Table'!$F$42),'Reference Table'!$G$42,
AND([@Tier4]='Reference Table'!$E$43,[@Policy]='Reference Table'!$F$43),'Reference Table'!$G$43,
[@Tier4]="Tier 1",
VLOOKUP([@Material5]&[@Diameter2]&[@Tier4],CHOOSE({1,2},'Reference Table'!$C$2:$C$44&'Reference Table'!$E$2:$E$44,'Reference Table'!$G$2:$G$44),2,FALSE)
I can work with IFS formula only in excel online but i know the syntax of this formula and i tried to adapt IF formula to IFS. I hope it works.
- Thank You It worked !
What does the CHOOSE({1,2} actually do ? Its all new to me
=IFS([@Tier4]='Reference Table'!$E$44,'Reference Table'!$G$44,AND([@Tier4]='Reference Table'!$E$42,[@Policy]='Reference Table'!$F$42),'Reference Table'!$G$42,AND([@Tier4]='Reference Table'!$E$43,[@Policy]='Reference Table'!$F$43),'Reference Table'!$G$43,[@Tier4]="Tier 1",VLOOKUP([@Material5]&[@Diameter2]&[@Tier4],CHOOSE({1,2},'Reference Table'!$C$2:$C$44&'Reference Table'!$E$2:$E$44,'Reference Table'!$G$2:$G$44),2,FALSE)
