Help with countif & index formula

Hi,

I got help a while ago on this formula and it's been great use for me but I now need some help expanding it. The forumla works well with one set of data but I now need it expanded across two sections of data in different columns.

I have attached an example spreadsheet which shows the first set of output data picking up anything which has "include" next to it (column B). Now I am wanting to hopefully add column E as well in the search. Is this possible? Your help would be greatly appreciated. Let me know if it doesn't make sense.

Hi

H4: =IF(ROWS(H$3:$H3)<=COUNTIF($C$5:$C$1158,$H$3),INDEX($B:$B,SMALL(IF($C$5:$C$1158=$H$3,ROW($B$5:$B$1158),""),ROWS(AF$7:$AF7))),
IF(ROWS(H$3:H3)-COUNTIF(C:C,$H$3)<=COUNTIF(F:F,$H$3),INDEX(E:E,SMALL(IF(F:F=$H$3,ROW(F:F),""),ROWS(H$3:H3)-COUNTIF(C:C,$H$3))),""))

Array entered...

rylo

That's fantastic, thanks so much for your help

Hi Rylo,

Sorry to be a pain but if I am wanting to add a 3rd column of data, I couldn't get the formula to work properly. Can you please help me?

Cheers

Don't worry I got it to work, put a ( in the wrong spot. All good, thanks.