I have a table of zip codes (column F) for which I need the associated crime rates populated (columns H and I):
Screen Shot 2015-06-27 at 3.43.24 PM.png
So far, I've created a web query in another worksheet that returns the crime rate for whatever zip code is entered (cell B1) as follows:
Screen Shot 2015-06-27 at 3.45.53 PM.png
What would be the most efficient way to populate the values of cells B5 and B6 from the above query into the appropriate columns within the zip code table for each different zip code?
Bookmarks