- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 05, 2023 06:24 PM
I need some help trying to write a conditional formula...
The idea is IF any cell in column 1 is duplicative/match entry, then look at corresponding column 2 cells and merge merge into corresponding column 3.
Is if A2 and A45 match look at/merge B2 and B45 into C2 and C45
Is something like this possible?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 06, 2023 02:36 AM
What you describe is not really core functionality of Airtable, although it could be achieved with a relatively complex automation. It sounds like you might be making the mistake of thinking about Airtable as a spreadsheet rather than a database though. Can you describe the structure of your Base?
