Consider re-arranging your data in a matrix, then you can use an Index/Match combination.
=INDEX($H$4:$I$5,MATCH(A10,$G$4:$G$5,1),MATCH(B10,$H$3:$I$3,1))
2017-06-09_16-48-39.png
Consider re-arranging your data in a matrix, then you can use an Index/Match combination.
=INDEX($H$4:$I$5,MATCH(A10,$G$4:$G$5,1),MATCH(B10,$H$3:$I$3,1))
2017-06-09_16-48-39.png
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks