Using A Picklist and searching for data

Hi All,

Hope you are well.

I'm having trouble trying to find a solution to something;

I have a picklist in A3, on the same sheet I would like to display certain data from the data sheet sheet that is related to a column K (where picklist values are).

In column K in the data sheet, it could have several items off the picklist in one cell.

So I require the search formulae to use the single selected A3, look in column K on data sheet then display the values.

If I select SMART in A3 picklist, and K in the data sheet has; cells with, "SMART" or "SMART, FINANCE", or "SALES, SMART" - i want to return all these rows via just selecting SMART in the picklist

=IF(ISERROR(INDEX('Data'!$A:$K,SMALL(IF('Data'!$K:$K=$A$3,ROW('Data'!$K:$K)),ROW(1:1)),1)),"",INDEX('Data'!$A:$K,SMALL(IF('Data'!$K:$K=$A$3,ROW('Data'!$K:$K)),ROW(1:1)),1))

Please help!