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.
Please anyone.
=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.