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     www.energyefficientbuild.com.   Jun-18-2014
post by Carl Wicker: (https://productforums.google.com/forum/#!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: http://xxxxxxxxxxxxxxxx.com/xxxxx/xxxx.xxx 
Blacklist Sheet is formatted: xxxxxxxx.com

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.
https://docs.google.com/spreadsheets/d/1pf7aT2soxCceMJVgzzvqOG-WjQ-ylpvCXcNCAm5oFoo
Here's the blacklist reference sheet
https://docs.google.com/spreadsheets/d/1XbqJJnx9eKnQDNdDJ_85ps058CwFxNkuTrUZY8AVf8Y

--------------------------------------------------------------------------------------------------