In J2 entercommitted as an array formula ( With Ctrl+Shift+Enter)Formula:
=INDEX($E$2:$E$13,MATCH(1,($B$2:$B$13=$H2)*($D$2:$D$13=J$1),0))
Drag down and right
In J2 entercommitted as an array formula ( With Ctrl+Shift+Enter)Formula:
=INDEX($E$2:$E$13,MATCH(1,($B$2:$B$13=$H2)*($D$2:$D$13=J$1),0))
Drag down and right
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks