Google Sheets, query. Not sure how to import data to corresponding cells.
query(IMPORTDATA(“https://www.iftach.org/taxmatrix/charts/4Q2020.csv”), “Select Col4 where Col1 = ‘”&A4:A&”‘”))
Where range A4:A is a list of the states
This one works fine
query(IMPORTDATA(“https://www.iftach.org/taxmatrix/charts/3Q2020.csv”), “Select Col4 where Col1 is not null and Col1<>’44013′”) (it’s just give me some extra line with text 44013). but it just imports data. I need to import this data, but checking first A4:A.
If you can help me, I would be really happy.