Combining INDEX/MATCH with several criteria and INDEX/SMALL

I am playing around with Index in an effort to finally learn it.
I have however come to a snag for which I cannot find a thread.

I would greatly appreciate if someone could point me to the correct thread or a solution!

I have found a way to find a value that meets three criterias:

Please Login or Register  to view this content.

This only finds the first value, and not the rest.

I have also found a way to find all the values, (and sort them in multiple columns), but this only accepts one criteria:

Please Login or Register  to view this content.

How do I combine these into one sentence?

I tried by entering an AND statement to the IF statement in the second, but this returns the heading of the column in the table where I look.

=IFERROR(INDEX(Data_Entry[[#All];[NPS E-mail adress]];SMALL(IF((Menu!$B$3=Data_Entry[[#All];[Order Type]])*(Data_Entry[[#All];[Add to eMarketeer]]=Menu!$A$2)*(Data_Entry[[#All];[Sent?]]= Menu!$A$3);0);ROW(Data_Entry[[#All];[NPS E-mail adress]])-MIN(ROW(Data_Entry[[#All];[NPS E-mail adress]]))+1);COLUMNS($C$5:C5)));"")

Originally Posted by tim201110

=IFERROR(INDEX(Data_Entry[[#All];[NPS E-mail adress]];SMALL(IF((Menu!$B$3=Data_Entry[[#All];[Order Type]])*(Data_Entry[[#All];[Add to eMarketeer]]=Menu!$A$2)*(Data_Entry[[#All];[Sent?]]= Menu!$A$3);0);ROW(Data_Entry[[#All];[NPS E-mail adress]])-MIN(ROW(Data_Entry[[#All];[NPS E-mail adress]]))+1);COLUMNS($C$5:C5)));"")

Thank you for the quick reply!
This does however only return the heading of the table, and nothing more.

Excel INDEX MATCH SMALL.gif

Originally Posted by shukla.ankur281190

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I have done so!

=IFERROR(INDEX(Data_Entry[[#All],[NPS E-mail adress]],AGGREGATE(15,6,ROW(Data_Entry[[#All],[Order Type]])/(Menu!$B$3=Data_Entry[[#All],[Order Type]])/(Data_Entry[[#All],[Add to eMarketeer]]=Menu!$A$2)/(Data_Entry[[#All],[Sent?]]= Menu!$A$3),COLUMNS($C$5:C5))),"")
not array

Originally Posted by tim201110

=IFERROR(INDEX(Data_Entry[[#All],[NPS E-mail adress]],AGGREGATE(15,6,ROW(Data_Entry[[#All],[Order Type]])/(Menu!$B$3=Data_Entry[[#All],[Order Type]])/(Data_Entry[[#All],[Add to eMarketeer]]=Menu!$A$2)/(Data_Entry[[#All],[Sent?]]= Menu!$A$3),COLUMNS($C$5:C5))),"")
not array

Super! This works. Thank you very much!
As it is now not an array anymore. How do one lock Data_Entry[[#All];[NPS E-mail adress]] like $B4 to prevent it from changing when copying the cells to other cells?

I have tried that, but it only returns the last entry. Copy paste works for now. I was just curious.

Thank you for your help and assistance!

Ahh!

I had a write error in the real file. Thank you very much!