Using your sample, try:
=INDEX($C$2:$C$10,MATCH(1,INDEX(($A$2:$A$10=A11)*($B$2:$B$10=B11),0),0))
adjust ranges/references to suit.
Using your sample, try:
=INDEX($C$2:$C$10,MATCH(1,INDEX(($A$2:$A$10=A11)*($B$2:$B$10=B11),0),0))
adjust ranges/references to suit.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks