Hi,
Enter these array formulas (confirm with CTRL+SHIFT+ENTER, not just ENTER):
In cell I3:
=INDEX($B$2:$B$9,MATCH(H3&"-"&G3,$A$2:$A$9&"-"&$C$2:$C$9,0),1)
In cell J3:
=INDEX($D$2:$D$9,MATCH(H3&"-"&G3,$A$2:$A$9&"-"&$C$2:$C$9,0),1)
Regards
Hi,
Enter these array formulas (confirm with CTRL+SHIFT+ENTER, not just ENTER):
In cell I3:
=INDEX($B$2:$B$9,MATCH(H3&"-"&G3,$A$2:$A$9&"-"&$C$2:$C$9,0),1)
In cell J3:
=INDEX($D$2:$D$9,MATCH(H3&"-"&G3,$A$2:$A$9&"-"&$C$2:$C$9,0),1)
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks