Why the double unary minus, Marcelo?
If you are wanting an arithmetic operation to coerce the boolean to a
number, won't the multiplication do it anyway?

And are you sure that the formula will work with the unequal ranges?
Oughn't the C3 to be C500?
--
David Biddulph

Marcelo wrote:
Paul, you can use a sumproduct funcion

=sumproduct(--(a2:a500=1)*(b2:b500=2)*(c2:c3=3),(d2:d500))

hth

I have the following situation:

I have a sheet that I need to lookup "Name" when "Col A" = value 1
AND "Col B" = value 2, and "Col 3" = value 3. There is only one
unique solution.

Basically I need a Vlookup with an "AND" function. The value that I
am looking for a text field, or else I would try a pivot table.

Help.