Hello,

I have a scenario I need some help with. The goal is to get values from one colum into one cell,in a linear format, based on a value in the same row, but a different column.

Example:

If the value in column I is equal to value of M5, then insert the value of column J in the same row as the previously matched value in column I.

There will be multiple matches found in the column and i need them to be displayed in a linear fashion separated by a space so they can be recognized by another program.

The number of values in column N5(the target for the data) will vary based on the number of matched values.

The end result would be something like $J5 $J6 $J7 $J8 $J9 $J10 $J11...

I'm kind of new to excel so please be forgiving, Thanks!