+ Reply to Thread
Results 1 to 4 of 4

Simple Google Sheets VLOOKUP script

  1. #1
    Registered User
    Join Date
    07-26-2019
    Location
    NY
    MS-Off Ver
    1906, latest
    Posts
    19

    Cool 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

  2. #2
    Registered User
    Join Date
    07-26-2019
    Location
    NY
    MS-Off Ver
    1906, latest
    Posts
    19

    Re: Simple Google Sheets VLOOKUP script

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

  3. #3
    Registered User
    Join Date
    07-26-2019
    Location
    NY
    MS-Off Ver
    1906, latest
    Posts
    19

    Re: Simple Google Sheets VLOOKUP script

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

  4. #4
    Forum Contributor
    Join Date
    08-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    782

    Re: Simple Google Sheets VLOOKUP script

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Google sheets script to download file and save it to google drive folder and use it's data
    By western in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 01-18-2021, 01:31 PM
  2. Help with the Google Sheets script
    By ronin76 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 12-13-2020, 12:28 PM
  3. [SOLVED] Google Sheets - Add Timestamp Script to Button.
    By IFSSCref in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 12-04-2019, 04:20 PM
  4. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  5. [SOLVED] Google sheets, auto email by script
    By Ditch1983 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 05-16-2017, 08:10 AM
  6. Google Sheets Script not working
    By jsmity in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 02-02-2017, 11:36 AM
  7. google sheets button with script
    By tselek1985 in forum Excel General
    Replies: 1
    Last Post: 10-17-2016, 06:18 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1