IF Formulas Help

[PickThisBerry]

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?

[David_Skinner]

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?