• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Match results from 3 criteria, from Row and Columns

Juniad

Member
Enter this formula in AZ7 with key combination Ctrl + Shift + Enter
=IFERROR(INDEX($C$2:$Y$66,MATCH(1,($A$2:$A$66=AZ3)*($B$2:$B$66=AZ4),0),MATCH(AZ5,$C$1:$Y$1,0)+1),"Record Not Found")
 
Top