Saturday, June 21, 2014

yogi_Pull Data By Matching A Column In The Spreadsheet With A Column in Another Sheet (spreadsheet)

                                         Google Spreadsheet   Post  #1679
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jun-18-2014
post by Carl Wicker: (!category-topic/docs/spreadsheets/9XxtjVsCiko)
Filtering from another spreadsheet
I currently have 2 spreadsheets, one with a imported JSON list of urls.  another with a list of blacklist sites.

Imported JSON URL Sheet 1 is url formatting is: 
Blacklist Sheet is formatted:

I would like the end result to be just a list of blacklisted links from the JSON urls.

I haven't used sheets much but I'm keen to learn.

Thanks in advance

Hey ya Bob,
Here's the JSON in a sheet with an additional column added to check out Ivanna's suggestion.
Here's the blacklist reference sheet