• 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

Pasadu

Member
Sir, Please I want the results to be displayed when the criteria are selected from the drop-down list. Thank you in advance.

80998
 

Attachments

  • Fetch criteria.xlsx
    41.4 KB · Views: 12
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")
 
Back
Top