double index match

[duane]

if there is only one unique record sumproduct will do it
assume your columns are a, b, c - rows 2-5 for the data, and th
element is a number

=sumproduct((a2:a5="xyz")*(b2:b5=120)*(c2:c5)

 

[Frank Kabel]

Hi
try the following array formula (entered with cTRL+SHIFT+ENTER):
=INDEX(C1:C100,MATCH(1,(A1:A100="XYZ")*(B1:B100=120),0))

 

[fernando cinquegrani]

Area CC Element
XYZ 120 120500
ABC 120 120500
how i get the 120500 relating to XYZ and CC 120

in this case
in A11 XYZ
in B11 120
=VLOOKUP(A11:B11,A2:C10,3,0) [Ctrl+Shift+Enter]

but
=INDEX(C2:C10,MATCH(A11 & "|" & B11,A2:A10 & "|" & B2:B10,0),1) [Ctrl+Shift+Enter]
if you have
Area CC Element
XYZ ZZ 120500
XY ZZZ 120000
.f
http://www.prodomosua.it

 

[fernando cinquegrani]

oops!

in this case
in A11 XYZ
in B11 120

=INDEX(C2:C10,MATCH(A11 & B11,A2:A10 & B2:B10,0),1) [Cntl+Shift+Enter]

but
=INDEX(C2:C10,MATCH(A11 & "|" & B11,A2:A10 & "|" & B2:B10,0),1) [Ctrl+Shift+Enter]
if you have
Area CC Element
XYZ ZZ 120500
XY ZZZ 120000
.f
http://www.prodomosua.it

 

[kumar]

Area CC Element

XYZ 120 120500

ABC 120 120500

XYZ 250 135000
DEF 250 120500
how i get the 120500 relating to XYZ and CC 120

Help with double math function pls