Auto Select Country based on city select

Hi, I want automatically select the country based on the city typed by the user.
Texas = USA
Tokyo = Japan
most solutions use a calculate such as “if(${city} = ‘Texas’ , '1__USA,‘nochoice’)”
however, I have over 1000 cities so I’d prefer something more dynamic.
(P.S my choices sheet contains both city & country)
How can I do this?

@kobo7805, these posts discussed previously should help you solve your issue:

And this post too …