I have a column of city names in excel FILE A. In the column directly to the
right of the city, I want a formula to lookup from FILE B and enter the
correct county name from another work sheet column.

FILE B contains a column of all the possible city names and a column of
their county names.

I'd be so happy to have some help on this. Thanks.