Simple VLOOKUP Script

[meowmeow22]

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

[Pepe Le Mokko]

Please post in the correct subforum (Googlehseet?) and attach the sheet to your post.External links are untrustworthy and not all our members can access them Thanks