SWITCH / MATCH

[Bedford]

Confused about why this formula isn't working. I had it working for 2 columns of criteria; "Set" in column B and "Part" in column C, adding columns D & C have me stumped.

=IFNA(INDEX(SWITCH(E5,"Set",CUSTOMERS!$B:$B,"Part",CUSTOMERS!$C:$C),"FMA",CUSTOMERS!$D:$D),"OTHER",CUSTOMERS!$E:$E),MATCH(D5,CUSTOMERS!$A:$A,0)),"")​

Please anyone.

 

[Fluff]

You need to remove the bracket before "FMA" and "OTHER"

 

[Bedford]

You need to remove the bracket before "FMA" and "OTHER"

Okay, that worked. Thank you very much!

 

[Fluff]

You're welcome & thanks for the feedback.