Forum Discussion
Umair_Yousuf
Aug 30, 2019Copper Contributor
Index MATCH formula returns the next value in an array
Hello Would appreciate if I can get some help on this problem. If you please look at the attached excel file, I am trying to lookup value from one data set, into another. However, the index match f...
Subodh_Tiwari_sktneer
Aug 30, 2019Silver Contributor
You may try the following Array Formula which requires confirmation with Ctrl+Shift+Enter instead of Enter alone.
In C3
=IFERROR(INDEX($G$3:$G$5,SMALL(IF($E$3:$E$5=A3,IF($F$3:$F$5=B3,ROW($E$3:$E$5)-ROW($E$3)+1)),ROWS(C$3:C3))),"Record not in File B")
Confirm it with Ctrl+Shift+Enter and then copy it down.
Umair_Yousuf
Aug 30, 2019Copper Contributor