Autofill from a list

[BrandieLaine]

I have a call report summary that contains the city from which the call originated.  I need to be able to sort the data based upon the county from which it originated.  In a separate spreadsheet, I have a list of cities and their corresponding counties.  I need to be able to add a column to my call report summary and have that column populate with the names of the counties matching the corresponding cities.  I have attached a very simplistic version of my dilemma.  Any suggestions would be greatly appreciated. 

[#2 · Accepted solution]

@BrandieLaine 

=VLOOKUP(B2,Sheet1!$B$2:$C$6,2,FALSE)

Is this what you want to do?

[#3]

No. When I do that, it is coming back with a "0". I need it to populate the county name.

[#4]

@BrandieLaine 

The County names are County A, County B, County C and so on, is this right?

The formula returns these names, see attached sheet and the attached file of the earlier post.

[#5]

Yes! It did work. I apparently had a typo the first time I tried it. Thank you so much for your help!