I have something like this:
I need some formula which get the value of cell C10="informatics" coming from the condition that the results is 70 and the student is Lucy. I tried several ways...until now i reach that point:
IFERROR(INDEX(C:C;MATCH("70",B:B,0))"None")
But of course it gaves me Carl results on math.
You were pretty close, just needed concatenate data:
=INDEX($C$2:$C$11;MATCH(C18&D18;$A$2:$A$11&$B$2:$B$11;0))
or directly
=INDEX($C$2:$C$11;MATCH("lucy70";$A$2:$A$11&$B$2:$B$11;0))
Depending on your Excel version, you may need to enter the formula as an array formula, so introduce it pressing ENTER+SHIFT+CTRL