Simple Google Sheets VLOOKUP script

Hi Excel Forum, Thanks for your help in the past with my projects. I just had a quick question. It seems simple but can't figure it out.

Our goal is to perform a search on Column A, "Bad List", on sheet Bad List Reference and if any word (e.g., "student") is contained in Column F, "Title", then that entire row gets deleted.

For example, since Julian Rutz, row 5, has student in his title, and the word student exists in Bad List, his entire row would be deleted.

Ideally, we want a Google Script to run every week to check the list against Column F, for title, and delete the bad rows.

Here is the GSheet: https://docs.google.com/spreadsheets...6k8rsiL2Pr5_TQ

Will you please advise?

Thanks again, I really appreciate it.
Alex

Hi team,
Just bumping this up - could anyone help?

Hi team,
Just bumping this up - could anyone help?

Hi,
Please try the link in below that I've set a trigger to let it run automatically every Monday at 5-6am or you can change to your desire day and time

https://docs.google.com/spreadsheets...YKo/edit#gid=0

Regards,
tt3