=IF(AND(B3="H",LEFT(CSV!C3,3)<>"LVLZ",C3="ALUM",AL3="_2"),COUNTIF('EDGES & BEND ALLOWANCE'!$Z$2:$Z$501,AM3)>0,
IF(AND(B3="H",LEFT(CSV!C3,3)<>"LVLZ",C3="ALUM",AL3="_25"),COUNTIF('EDGES & BEND ALLOWANCE'!$AA$2:$AA$501,AM3)>0,
IF(AND(B3="H",LEFT(CSV!C3,3)<>"LVLZ",C3="ALUM",AL3="_3"),COUNTIF('EDGES & BEND ALLOWANCE'!$AB$2:$AB$501,AM3)>0,
IF(AND(B3="H",LEFT(CSV!C3,3)<>"LVLZ",C3="ALUM",AL3="_35"),COUNTIF('EDGES & BEND ALLOWANCE'!$AC$2:$AC$501,AM3)>0,
IF(AND(B3="H",LEFT(CSV!C3,3)<>"LVLZ",C3="ALUM",AL3="_4"),COUNTIF('EDGES & BEND ALLOWANCE'!$AD$2:$AD$501,AM3)>0,
IF(AND(B3="V",LEFT(CSV!C3,3)<>"LVLZ",C3="ALUM",AL3="_2"),COUNTIF('EDGES & BEND ALLOWANCE'!$AF$2:$AF$502,AM3)>0,
IF(AND(B3="V",LEFT(CSV!C3,3)<>"LVLZ",C3="ALUM",AL3="_25"),COUNTIF('EDGES & BEND ALLOWANCE'!$AG$2:$AG$501,AM3)>0,
IF(AND(B3="V",LEFT(CSV!C3,3)<>"LVLZ",C3="ALUM",AL3="_3"),COUNTIF('EDGES & BEND ALLOWANCE'!$AH$2:$AH$501,AM3)>0,
IF(AND(B3="V",LEFT(CSV!C3,3)<>"LVLZ",C3="ALUM",AL3="_35"),COUNTIF('EDGES & BEND ALLOWANCE'!$AI$2:$AIC$501,AM3)>0,
IF(AND(B3="V",LEFT(CSV!C3,3)<>"LVLZ",C3="ALUM",AL3="_4"),COUNTIF('EDGES & BEND ALLOWANCE'!$AJ$2:$AJ$501,AM3)>0,
IF(AND(B3="H",C3="ALUM"),COUNTIF('EDGES & BEND ALLOWANCE'!$Y$2:$Y$501,AM3)>0,
IF(AND(B3="V",C3="ALUM"),COUNTIF('EDGES & BEND ALLOWANCE'!$AE$2:$AE$501,AM3)>0,
IF(AND(B3="H",C3="ZINC"),COUNTIF('EDGES & BEND ALLOWANCE'!$AK$2:$AK$501,AM3)>0,
IF(AND(B3="V",C3="ZINC"),COUNTIF('EDGES & BEND ALLOWANCE'!$AL$2:$AL$501,AM3)>0))))))))))))))
Following the logic I was talking about in post #13 and what others have said already, I've placed the IF statements with more conditions first, as they need to be dealt with before those with fewer, otherwise those with fewer will cause a false positive and stop calculations early on.
Bookmarks