Match a County to a City found in an Address

[ExcelBrent]

Hey, I am looking for some guidance on how I might achieve the following:

I have a column (column H) of full addresses, for example:
1234 SW 80th Pl, Miami, FL 33331

On another sheet, I have a list of COUNTIES in column A, and CITY in column B.

COUNTY	CITY
Palm Beach	Acacia Villas
Alachua	Alachua
Orange	Alafaya
Jackson	Alford
Santa Rosa	Allentown

I am needing to search the contents of the full address for the CITY and return the COUNTY that the city is located in.

I am trying to end up with a column that has the COUNTY associated with the address, so I can copy and paste the column values into a "County" column on the same sheet with the addresses.

I can find it with:

=IF(ISNUMBER(SEARCH(B520,Sheet2!$H$2)),A520,"FALSE")

However, this results in a full column of "FALSE" except for the located CITY. The below image is the result using the example address above. Column C is all FALSE except for the row 520, result is "Miami-Dade" which is correct; CITY in address = Miami and COUNTY = Miami-Dade.

Then to get the next address I would have to go horizontal to the next column which then I would search the address in Sheet2!$H$3.
I feel like there is a better approach. Any assistance is appreciated!

 

[JamesCanale]

MrExcelPlayground13.xlsx
	A	B
1	COUNTY	CITY
2	Palm Beach	Acacia Villas
3	Alachua	Alachua
4	Orange	Alafaya
5	Jackson	Alford
6	Santa Rosa	Allentown
7
8
9	123 john street, Acacia Villas, FL 12345	Palm Beach
10	456 west street, Alachua, AK 99948	Alachua
11	1600 Penn Avenue, Washington DC 33333	No Match
12	10-110 Harry Avenue, Allentown, PA 22222	Santa Rosa
Sheet7

Cell Formulas
Range	Formula
B9:B12	B9	=IFERROR(FILTER($A$2:$A$6,NOT(ISERR(SEARCH($B$2:$B$6,A9)))),"No Match")