Forum Discussion
Combining Index and Match Functions
I have achieved retrieving data from column L & M to column D & E by using formula " {=INDEX($L$3:$L$8,MATCH(B3&C3,$I$3:$I$8&$K$3:$K$8,0))} " in office 365 excel version. Whereas, not getting the res...
It works as regular formula (not array one) on both versions. And what's wrong on 2013? Screenshot is practically not recognizable.