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

Retrieve data multiple match creteria

Dear friends
Here I have a question want to retrieve eng name list from data sheet in result sheet matching given criteria in filter . if there value 1 as respected selected filter retrieve eng name below in D3 .
Thanking you.
 

Attachments

  • Retrive data multiple match.xlsx
    13.6 KB · Views: 13
Try...........

In D3, formula copied down :

=IFERROR(INDEX(Data!A:A,AGGREGATE(15,6,ROW(Data!B$2:B$23)/(Data!B$2:B$23=B$2)/(INDEX(Data!C$2:K$23,0,MATCH(C$2,Data!C$1:K$1,0))=1),ROW(A1))),"")

77256
 
If you have an Excel version that support the FILTER function, a formula in one cell only (D3), don't copy down/across/anywhere:
Code:
=FILTER(Data!A2:A23,(INDEX(Data!A2:K23,0,MATCH(Result!C2,Data!A1:K1,0))=1)*(Data!B2:B23=B2),"no-one")
 
Thans for your reply
Filter is available , I am working on office 365. Not old version. Your code showing only one name and repeating same not comming multiple name as in data file matching creteria.
 
Back
Top