Sunday, June 22, 2014

yogi_From Results Of ImportJASON Contents Of Which Contain URLs In Sheet Named 'blacklistUrls'

                                         Google Spreadsheet   Post  #1680
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-22-2014
post by Carl Wicker: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/9XxtjVsCiko)
Filtering from another spreadsheet
this is an additional solution to the one I had provided in my following blog post
yogi_Pull Data By Matching A Column In The Spreadsheet With A Column in Another Sheet (spreadsheet)
http://yogi--anand-consulting.blogspot.com/2014/06/yogipull-data-by-matching-column-in.html 
I have provided solution presented here in response to a comment from Carl:

"Once again, a big thanks for everyone's help, here's a template for the end goal.

https://docs.google.com/spreadsheets/d/1gFgWpSCLTLQvfOENRdJrVGJB_qc7JkpiTl-BJloy4Jc

Im having some problems moving the formulas around to display in the correct positions.

Is it possible to paste a JSON Url in a cell, then the JSON formula can reference it and then list results?"

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