I need to do a similar join of DB 2 tables.
My 2 tables are presented in Excel as in this example:

TABLE1:
COUNTRY STATE
usa NY
usa VT

TABLE2:
STATE CITY
NY New York
NY Buffalo
VT Burlington

I need to have the join result as follow:

TABLE3:
COUNTRY STATE CITY
usa NY New York
usa NY Buffalo
usa VT Burling

Currently exploring which (1) predefined function or (2) formula could do this.
I have thousands of CITY equivalent, 100 of STATE equivalent.
(3) VB would be my last resort.
Any help is appreciated.