I have two sheets: pricelist and products. In products an "x" should
appear when in pricelist an "x" is added in the referenced packing
column. In both sheets the product names are to be found in column B.
These packings a

C=125 ml
D=250 ml
E=500 ml
F=500 ml+
G=1,0 liter
H=2,5 liter
I=5,0 liter
J=10,0 liter
K=0,75 kg
L=1,0 kg

In pricelist as well as in products there are empty spaces in each
productline, but since there is no tag ("x") in the concerning column,
there does not appear an "x" in the product column. Only when the
packing is 1,0 liter, the formula suddenly decides that both conditions
are true, where there is absolutely no "x" on empty spaces nowhere in
the pricelist-sheet...

My formula used is this one:


=IF(SUMPRODUCT(--(pricelist!$G$3:$G$250="x")*--(pricelist!$B$3:$B$250=$B3))<0;"x";"")

Ofcourse I can rule out all the blank spaces from being checked, by
adding IF(SUM($B3)="";"" to the formula, but I want to know why my
perfectly working formula is not working on the 1,0 liter column...
Anyone please?

Paul


--
Herman56
------------------------------------------------------------------------
Herman56's Profile: http://www.excelforum.com/member.php...o&userid=31018
View this thread: http://www.excelforum.com/showthread...hreadid=527952