Index Match Match problem

[gheyman]

=INDEX(WBS_Dictionary!$E:$E,MATCH($A10,WBS_Dictionary!C:C,0),MATCH(C10,WBS_Dictionary!K:K,0))

If I take out either one of the matches from this formula I get an answer. But when I have both in the formula, like above, I get a #Ref !

Anyone know why?

 

[Aladin Akyurek]

Judging from what this formula suggests, I'd think rather...

Control+shift+enter, not just enter:

=INDEX(WBS_Dictionary!$E:$E,MATCH($A10,IF(WBS_Dictionary!K:K=C10,WBS_Dictionary!C:C),0))​

Note. Try to use definite ranges instead of whole columns for efficiency reasons.