Formula that can match values between to tables and insert a value based on matches

I hope I can explain this correctly :slightly_smiling_face:

We are looking for a formula, that will look for a match between the values of column A in table A with the values of column A in table B, and when there’s a match, return the values of column B in table B and insert them in column B table A. Note that there can be multiple returns, and the formula be able to handle this. I hope someone can help with this. Thanks, Mathias


@Mathias_Deichmann - correct me if I am getting this wrong but you should be able to do this with a filter formula on a column in Table A

TableB.Filter( ColumnA = Thisrow.ColumnA).ColumnB

Can you give this a try and let me know if this helps?

These are two good threads on this topic too -

1 Like

Thank You Malika. We are just starting out, and Coda is exactly what we have been looking for.

1 Like