Sort of using Vlookup in QuickBase- setting up a field to look through multiple records and then match and assign

Hello

I have 20k records with about 124 fields in table -1.
One of the field is City (Text field).
Now i have another table-2 where i have added all 150 Cities assigned to us and each City has unique Region Code (BC1A, BC 2A sort of).
I want to recreate that same Region field in Table 1 with all the records.
I have tried creating a formula-text field and apply the if-else as well as case condition but it returns error that City field needs text value which confuses me further as its already a text field.
is there a way to automate this filed.

Thanks for your help.

------------------------------
Amandeep Dhillon
------------------------------