Help please!

I have a worksheet "receiving data" column1 state; column 2 city county
name; column 3 gross (blank); column 4 tax(blank). I have a "data worksheet"
cities listed in column 1; county name in column 2; state in column 3; gross
amount column 4; tax amount column 5; there is a county totals after each
county. State total at the bottom

I need to look for the city county listed shown on the "receiving sheet" in
the "data worksheet" match the names then place the gross and tax info form
column 4 & 5 from the "data" into the receiving sheet.

I filtered just the county names and range named them; I did the same with
city. Now, I do not think that is correct because the forumla cannot match
the city with county. There could be 2 cities with the same name but be in
different counties.

I used Vlookup but it if did not find the city/county it returned an N/A.
I cannot total the columns when N/A is present.

How can I change the N/A to blank or zero? Should I range name the city and
county in the format the are currently in?