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

[Mathias_Deichmann]

Hi
I hope I can explain this correctly

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

01%20Projects|658x500

[mallika]

@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 -

Filter a list based on matching the corresponding info in another column

1st scenario: Make another column in Client Table called “Client’s Projects” and give it this formula: [Project Table].Filter(Client=thisRow) This will give you a comma separated list of all of a client’s projects. To take it a step further, you can wrap it in… BulletedList(...) …for your 2nd scenario. And because Coda is great, this will be a list of links to the actual projects/purchase orders; you can hover to see info or click to edit in a popup.

Lookup from other table

Dear Daniel, You made my day , your first suggestion worked out well Important is to mention to other users to benefit from this advise it to change the format to text to get the proper result.

[Mathias_Deichmann]

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