Filter/search multiple criteria within columns and across columns

[Reubenr90]

Hello,
I am working on building a database, of sorts, in Excel.
As a requirement we need to be able to filter by/return a set of results from multiple criteria within individual columns and across multiple columns.
Ideally we need to be able to perform this task using excel online which does not appear to support macros or advanced filtering.
In order to save on the number of rows, criteria may be contained within a substring (keywords, in this example).

So, in the below (and attached) example table, I want to view all results containing 2010 in column C OR keyword in column D 1 OR keyword 3 in column D.

This would return rows 2, 3, 5 & 6.

A B C D
1 Title Author Year Keywords
2 Title 1 Author 1 2010 Keyword 1; keyword 2; keyword 3; keyword 4
3 Title 2 Author 2 2020 keyword 4; keyword 3; keyword 1
4 Title 3 Author 3 2011 keyword 2
5 Title 4 Author 4 2010 keyword 3; keyword 2
6 Title 5 Author 5 2009 keyword 3; keyword 4; keyword 1
7 Title 6 Author 6 2010 keyword 4

Is this possible in the online environment? Is it even possible in the desktop version?
I appreciate any advice or pointers you can give me as I’ve been trawling the internet and coming up with nothing fruitful.

Cheers

[Reubenr90]

I have tried editing this post to update the table and the rows that should be returned, but I'm not seeing my revisions on this post.

Rows 2, 3 ,5 6 & 7 should be returned based on the criteria specified.

table within post:

Title	Author	Year	Keyword
Title 1	Author 1	2010	Keyword 1; keyword 2; keyword 3; keyword 4; keyword 5
Title 2	Author 2	2020	Keyword 4; keyword 3; keyword 1
Title 3	Author 3	2011	Keyword 2
Title 4	Author 4	2010	Keyword 3; Keyword 2
Title 5	Author 5	2009	Keyword 3; keyword 4; keyword 1
Title 6	Author 6	2010	Keyword 4

Also to call out that I have cross-posted on Chandoo as I did not see the cross-posting warning and am under a time constraint - i can't post a link in this comment, but it exists under the same title.

[JeteMc]

Here is a formula based proposal that might work with the online version.
The formula is:

Please Login or Register  to view this content.

I pasted the formula into cell F2, dragged the fill handle across to cell I2 and then, while F2:I2 were still selected, dragged the fill handle down to cell I7.
Let us know if you have any questions.