My list has 3 columns:

Column A Column B Column C
County State Office
Hall GA XYZ Office
Fulton GA ABC Office
Cuyahoga OH DEF Office

Etc, for about 500 rows.

I need to find the office that handles the county/state combo listed in
Column C. Some county names are replicated in other states, so I need
the one for the specific state.

The reference cells a County will be in cell G1, and State in H1.
These values are the result of a vlookup on another sheet.

How do I do this, please? Either a VBA or the formula would be great.

Thanks in advance.

Robert