Hi! I have an airtable base and within that base a table (table 1) several fields two of which are the email of the company and then a function that parses the email to get the company name.
In another table (table 2) in the same base I have linked the company name to an investment fund.
I am now trying to link the company in (table 1 ) to the fund it was linked to in table (2), how could I do this?
One edge case I anticipate is capitalization / spacing, other then that there shouldn't be issues.
I believe I need to use a lookup field but am having issues with configuration