Keyword Search using AND criteria embedded in INDEX

I have 3 keywords to look for in an array. They must all be present in a cell and recognized in any order. EXAMPLE: I'm looking for A, B, and C. The cell might contain "A,B,C", "A,C,B", "C,B,A", etc. It needs to find them all.

Here's what I've got that successfully pulls the array for the first keyword. Assume my first keyword is in A2. Second and third would go in A3 and A4, respectively.

Data set being searched lives in the "Lock_Full Data" sheet. The search results are populated on their own sheet, "Search Results".

I absolutely can't figure out how to look for multiple values!

=IF($A$2="","",IF(ISERROR(INDEX('Lock_Full Data'!$A:$D,SMALL(IF(ISNUMBER(SEARCH($A$2,'Lock_Full Data'!$D:$D)),ROW('Lock_Full Data'!$D:$D)),ROW(7:7)),1)),"",INDEX('Lock_Full Data'!$A:$D,SMALL(IF(ISNUMBER(SEARCH($A$2,'Lock_Full Data'!$D:$D)),ROW('Lock_Full Data'!$D:$D)),ROW(7:7)),1)))