I want a cell to automatically display a text (T1, T2, T3, T4) based on whether or not the input in another cell is found in a table. (ie 020 = T2; 310 = T3 ect)
=IF(SUMPRODUCT(--(C3=I3:I16))>0,"T1") will list for just one category, but I cant get the formula to accept multiple arrays AND specific inputs when the value is in that array.
=IF(SUMPRODUCT(--(C3=I3:I16))>0,"T1")*(--(C3=J3:J16))>0,"T2") ect. What am I doing wrong?
*this is for tracking workload, I want the claim identifier to trigger the category input so a separate calculation will populate the workload credit.