google sheets – Compare imported range with existing range, and filling corresponded data to the fields

Please help!
Google Sheets, query. Not sure how to import data to corresponding cells.
query(IMPORTDATA(“”), “Select Col4 where Col1 = ‘”&A4:A&”‘”))
Where range A4:A is a list of the states

This one works fine
query(IMPORTDATA(“”), “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.