If cell(a1) = b1:b4 select the ajoining column value.
F Frank Kabel Aug 4, 2004 #2 Hi and what kind of result do you want? the sum? maybe a worksheet function will do? =SUMIF(B1:B4,A1,C1:C4)
Hi and what kind of result do you want? the sum? maybe a worksheet function will do? =SUMIF(B1:B4,A1,C1:C4)
