Search each row for multiple criteria (words) and return row number

Hello!

I am looking for a way to search an excel document row by row, and for this search to return a list of rows in which all of the search criteria are met.

For example, say there are five rows and I am looking to find "gray cat" and "mouse" in the same row. Each of these criteria will likely be in different cells, but in the same row.

Please be as descriptive as possible and thank you for your time.

Gray cat could be on its own OR a part of a sentence or a comma separated list of words.

The attachment was not uploading properly so I have copy and pasted the text which if copied and pasted into an excel doc should work.

Again this is searching for "gray cat" and "mouse" to occur in the same row.



Dog Cat Mouse Pig expected result
1 abc gray cat AB-123, [PO-ABCD/EFGH], mouse Row 2
2 abc black cat dog gray
3 abc purple cow 174-mse, [pie], abcde-123
4 bde blond gray cat 174-mse, [pie], abcde-123
5 der gray cat 174-mse, [pie], abcde-123
6 fre black dog AB-123, [PO-ABCD/EFGH]
7 get reckless moose 174-mse, [pie], abcde-123
8 bloating slipnot