how to Return multiple matching values from another table

[Soufiane_M]

Hi . Can you please suggest a solution to solve this ?

table : categories
id	tag	tag_ids
1	man	102
2	women	103
3	child	105

I would like to end up with:

table : product
id	product	tag	tag_ids
1	A	man|women	102|103
2	B	man|women|child	102|103|105
3	C	woman	103

I tried LOOKUP formula but it works  to return only one value , what about multiple values splited by "|" sign ??

Thank you

[1minManager]

So I assume these are 2 seperate tables...

In the second table you're going to have to setup [Tag] and [Tag_IDs] as ENUMLIST type columns.  Then have a formula for [Tag_IDs] as

Select(Table1[Tag_IDS],IN([Tag],[_ThisRow].[Tag])

Simon, 1minManager.com