How to select list data from table?

[sayan1]

Hi!

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.

[Aleksi · Accepted solution]

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

[sayan1]

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

[sayan1]

It Works! Thank you!
Your solution is simple

[Aleksi]

You’re welcome