Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to compare two field in different tables in the same base

Topic Labels: Formulas
430 1
cancel
Showing results for 
Search instead for 
Did you mean: 
amccown
4 - Data Explorer
4 - Data Explorer

I have two tables in the same base. Each has a field that contains a member number. However in table 1 the member number is a formula. How can I write a formula that will return a different field (member name) from the second table into a new field in the first table if the member number matches? In Excel I would use vLookup

1 Reply 1

The easiest way would be to create a linked field between the two tables, as this would let you use a lookup field like so:
Screenshot 2024-09-25 at 10.09.01 AM.png
Screenshot 2024-09-25 at 10.09.08 AM.png
https://support.airtable.com/docs/lookup-field-overview

---
If not, you'd need to use an automation to handle it for you, and it'd have a "Find Record" action followed by an "Update Record" action.  Airtable has a guide for that here: https://support.airtable.com/docs/using-record-templates-in-airtable