Trying to get a value using two conditions

[Cesar]

Hello
I need a formula to get an specific value when two conditions are given. For
example: The table would be.

Condition 1 Condition 2 Value
I E 70
SiC E 45
NSiC E 30
I L 45
SiC L 30
NSiC L 20

After filling out the table, in another sheet i'm adding the field:

Name Condition 1 Condition 2 Value
C.Garcia I L
(i need a formula to

get this value)

The list may have 100 rows. I tried to do it with DGET( ), but i couldn't.
Can somebody give me a hand on this?

 

[Duke Carey]

try

=SUMPRODUCT(--($A$1:$A$10=F1),--($B$1:$B$10=G1),$C$1:$C$10)

where the value to be looked up in the first column is in F1, and G1
contains the value to look up in the second column