VLookUp or Join/Collect with multiple cell entiers not working

Paul Eckerstorfer

Hi,

I am struggling with a tricky formular - need help.

What do I want?

1. I type in cell (Lot joined / 10) any Lot Number e.g. "LHA1" (--> see "black circle 1")
2. In cell (Lot joined / 11) only those TW numbers should be returned/displayed that are in the same line as the Lot Number "LHA1" in the yellow table above.

Thx.

Paul

Jason Duryea

In [Lot Joined]11 try using the formula below:

=JOIN(COLLECT([TW Number]2:[TW Number]6, [Lot joined]2:[Lot joined]6, CONTAINS([Lot joined]10)), '; ")

Paul Eckerstorfer

Hi Jason,

I already tried this --> #incorrect argument set.

Regard,

Paul