• 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.

Lookup Multiple Criteria and Results

K

Kenshin

Member
Hi good to see again, desperate need help again Im sorry because Im newbie and nowhere to look the answer


thank you
 

Attachments

  • Sample (4).xlsx
    18.8 KB · Views: 7
hello-You can to Use this Array (Ctrl+Shift+Enter)
Code: 
=IFERROR(INDEX(Master!$E$10:$E$500,SMALL(IF(Master!$D$10:$D$500=$C$5,IF(Master!$G$10:$G$500=$J$9,IF(Master!$I$10:$I$500=$J$10,IF(Master!$M$10:$M$500=$J$11,IF(Master!$V$10:$V$500=$J$12,ROW(A$10:A$500)-ROW(A$10)+1))))),ROWS($B$9:B9))),"")
 

Attachments

  • Sample 1.xlsx
    23.3 KB · Views: 9
You must log in or register to reply here.
Back
Top