I am trying to deliver a value in column "T" based on the value of 2 other columns (C & H). There are 18 possible combinations for C&H (3 options for C and 6 for H). I tried an imbedded IF AND statement and it worked until I saved it and came back, then I had the #VALUE error.
Is there another formula/method to solve for this? My basic data set it below:
If C1= AND H1= Then T1=
H S DataA H R DataB H B DataC H T DataD H I DataE H M DataF M S DataG M R DataH M B DataI M T DataJ M I DataK M S DataL
M M DataM L R DataN L B DataO L T DataP L I DataQ L S DataR L M DataS