Return value IF

[DeVille]

I have four columns. Column A, B, C and D.
I am trying to find a formula that returns the value in
column D from the row where column A, B and C all meet
certain conditions. Eg If all the following conditions
are true in one row, column A =1 and column B =2 and
column C =3 then what is the value in column D from the
same row.
I have tried sumproduct but that does not seem to work
If anyone can help thanks in advance

 

[Peo Sjoblom]

Why wouldn't sumproduct work?

=SUMPRODUCT(--(A2:A100=cond1),--(B2:B100=cond2),--(C2:C100=cond3),D2100)

 

[CLR]

You can insert a new column before A and Concatenate your old A1&B1&C1 into
the new A1 and copy down........then create a VLOOKUP table encompassing
columns A-E and use your desired Concatenation combination to VLOOKUP down
the new column A to find that combination and return the value from the
oldD/newE column..........

Vaya con Dios,
Chuck, CABGx3