How to select list data from table?


I have Products table and Seller Products table.
In Seller Products I have just Id of ther seller and Id of ther Product.

When seller wants to sell the products, I want to give them just the products where ID of the products equl to ID from Products Seller table.

For example like this
Select(Products[Name], IN(Seller Products[Id]))

I want to write this formula to the Suggested values field.

Please try like… SELECT(Products[Name],[ID]=[_THISROW].[Product ID])

1 Like

It’s just select by one ID.

I want to select data from two table. Like itersect, but different stucrter.

I want to give seller products description just they have

It Works! Thank you!
Your solution is simple :slight_smile:

You’re welcome