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.

Formula Help

Topic Labels: Formulas
964 1
cancel
Showing results for 
Search instead for 
Did you mean: 
PickThisBerry
6 - Interface Innovator
6 - Interface Innovator

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?

1 Reply 1

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?