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

[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.