Lookup data based on two columns

[Mohamed_Elrefae]

hello
i want to get data from two table that match two columns not one column

for the following i want to get data from another table that match column project and column set items in two tables
what i get from filter function that data match one column (set items) and neglect column (projects)

[Mohamed_Elrefae]

this is the screen shot for another table

[Pch]

Hi @Mohamed_Elrefae and Welcome to the Community !

I’m sorry but I’m not sure to understand what you’re trying to do …

@Mohamed_Elrefae

what i get from filter function that data match one column (set items) and neglect column (projects)

Could you please share a screenshot of the problematic filter formula you tried ?
(Or, if you can, share an anonymised sample doc reproducing your current setup and problematic part of it)

This might help us help you

[Mohamed_Elrefae]

please find the screen shot from my screen

[Mohamed_Elrefae]

@Pch

(Or, if you can, share an anonymised sample doc reproducing your current setup and problematic part of it)

tell me how to share sample doc

[Mohamed_Elrefae]

i modified the formula but also not working

[Pch]

Hi @Mohamed_Elrefae

For sharing a doc, you’ll find the instructions here

Sharing your doc

As for your issue, I tried to reproduce your setup as best as I could and I think something like this should work :

So, like in your formula, we take the table Progress and we ask Filter() to look for the rows where the value in your look up field [Set Items] contains thisRow.[Set Items] AND the value in your look up field Project contains thisRow.Project…
And this should return in your Progress look up the appropriate row

The thing here (from what I can see from your screenshots) is that you seem to compare a text value to a row … which simply can’t work . In the formula I shared above I compare a row to another row …

I’m not sure if the sample you’ll find below reproduce 100% of how your doc works but don’t hesitate to take a look

[Mohamed_Elrefae]

i tried but not working

this link to my coda doc

[Pch]

Thanks for sharing @Mohamed_Elrefae !

I seem to have corrected the formula … Well, at least, it doesn’t throw an error anymore !
Due to the language barrier though, I just can’t confirm the results are the right ones

[Pch]

I just modified the formula in the doc you shared @Mohamed_Elrefae …

Sorry, I didn’t see I could modify it earlier

[Mohamed_Elrefae]

Thank you for your Attention
i tried to get data from another table but not working
can you help me to get data from more than one table to a table

[Pch]

In a lookup field, you can only get the data from the concerned table

So, in your Progress lookup in your Set table, you can only get rows from your table Progress (where Set Items contains thisRow.[Set Items] AND Project contains thisRow.[Project])
Same goes for your view Inventory Transactions …

All I could do was to add a new lookup field from your table Inn Items to the Set table