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,

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.