Help return multiple unique values in a row. VLOOKUP?

[Royser12345]

Hello,

I have certain values in B column of a Summary tab (column "systems"). I would like to have a formula in C3 cell of a summary tab that would return multiple values from column J of a "source" tab mapped to the same system (column A of a source tab).
I was trying vlookup but it returns only 1 value and I need multiple and unique. Returned values not necessarily must be in one cell, they could be in dedicated cells each horizontally. example.xlsx

Thank you in advance!
Regards,

[samba_ravi]

d3

Please Login or Register  to view this content.

Try this and copy across

[Royser12345]

Siva,
thank you!
much appreciated.
Regards