Marcelo,

Sumproduct by design multiplies arrays which isn't much use when looking for
a text value. You'd have to be a bit more creative to achieve the desired
result with sumproduct. Try this

OFFSET(D1, SUMPRODUCT( (A2:A10=K1)*(B2:B10=L1)*(C2:C10=M1), ROW(D2:D10)-1
),0 )

Mike

"Marcelo" wrote:

Paul, you can use a sumproduct funcion

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

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Paul" escreveu:

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.