concatenation

ang_pia

On form B.  I added this formula.

I'm trying to concatenate all of values in a column named Request ID (in Form a) based on the value Description (in Form to the Vendor Number (Form A)

=INDEX([{Request ID}]1 + [{Request ID}]999, MATCH(Description$9, {Vendor Number}, 0))

Form A

Request ID     Vendor Number

123                 A

125                 B

126                 A

 

Form B

Vendor Number: A

 

Return Value should be "123, 126"

 

 

Paul Newcome

I am not sure what the reasoning is for this portion

 

[{Request ID}]1 + [{Request ID}]999

 

So I will just use {Request ID} as the reference and assume it is the entire column. I am also assuming the {Vendor Number} range is the same size.

 

Try something more along the lines of this:

 

=JOIN(COLLECT({Request ID}, {Vendor Number}, Description$9), ", ")