Updating fields based on matches within other fields

Hi everyone,

Thanks for looking at my question. Here’s what I’m trying to do:

I have multiple Tables in a Base; “Primary DB”, “DB2”, “DB3”, etc…

Inside of the “Primary DB” there are two Fields called “Company Name” and “Other DB”. The “Company Name” field is populated with … company names.

In all the other Tables I have one Field called “Company Name”.

I would like to create a formula in the Primary DB table / Other DB field that checks the values of the "“DB2” table / “Company Name” field, and if the values match, to fill in the Table name (“DB2” in this example).

And then for “DB3” and so on.

Is this possible?

Many thanks,