Filter and extract list of data based on criteria using INDEX MATCH

See this ...

Originally Posted by Phuocam

See this ...

There's no formula in it.....

I want formula (function) in J2

Sorry, I using Advanced Filter.

In J2

=IFERROR(INDEX(C$2:C$43,SMALL(IF(($B$2:$B$43=$H$2)*($A$2:$A$43=$H$3)*(($E$2:$E$43="Facebook")+($E$2:$E$43="Instagram")),ROW($A$2:$A$43)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Copy across and down

Originally Posted by JohnTopley

In J2

=IFERROR(INDEX(C$2:C$43,SMALL(IF(($B$2:$B$43=$H$2)*($A$2:$A$43=$H$3)*(($E$2:$E$43="Facebook")+($E$2:$E$43="Instagram")),ROW($A$2:$A$43)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Copy across and down

I've tried, but result is blank... Would you mind uploading the file that works plz...

See attached:

Originally Posted by JohnTopley

See attached:

It perfectly works.... You have my deepest thanks....... GoodLuck