Can anyone help me with this? I could swear I know how to do this/have done it before, but cannot seem to make it work.

Basically I have two worksheets with data. The first has sales figures based on City and State, but does not show the district (this is the info I am looking for) and I was not provided with the zip codes to pull in the district off just that one field (unless someone instead tells me how to retrieve all the zip code data easily (thousands of zip codes).

The second worksheet is a list of the districts and City, States that they represent. Basically I need to pull the District from worksheet 2 into worksheet 1 based on the City and State matching up. See below. Any ideas?

Thanks!

Worksheet 1
Sales Rank(A)- City (B) - State (C) - District? (D)
1 - Stockbridge - GA - {Formula to be entered here}
2 - Milton - MA - {Formula to be entered here}
3 - Lawrenceville - NJ - {Formula to be entered here}
4 - Marietta - PA - {Formula to be entered here}
5 - Marrietta - GA - {Formula to be entered here}

Worksheet 2
City (A) - State (B) - District (C)
Smyrna - DE - MD3
Milton - MA - NE1
Milton - VT - NE4
Lawrenceville - NJ - NJ4
Gainesville - NY - NY1
Marietta - PA - PA01
Marrietta - GA - SGA12
Stockbridge - GA - SGA14