L
lhkittle
Using
=SUMPRODUCT(B8:B16=B2)*(C8:C16=C2)*(D816)
Where drop downs in:
B2 = uPVC
C2 = 160
And this row exists in the table B816
uPVC 160 Class 16
Formula returns #value
Googled examples would have me believe "Class 16" should be returned.
Thanks.
Howard
=SUMPRODUCT(B8:B16=B2)*(C8:C16=C2)*(D816)
Where drop downs in:
B2 = uPVC
C2 = 160
And this row exists in the table B816
uPVC 160 Class 16
Formula returns #value
Googled examples would have me believe "Class 16" should be returned.
Thanks.
Howard