=CONCATENATE within an array

**gassiusmax** · 04-01-2015, 11:08 AM

I have an array formula that matches based on two sets of data, but now I am wondering if I could use Concatenate or the & feature too string multiple matches together in one string

For Example

the Formula that is in 'Work Summary'!V13:V43 matches the data from the Deductions sheet based on name and date but if there are multiple matches only the first is shown but what I would like to do is string together all results.

So the Name Marius in the deductions sheet has two different deductions one reason is 'Vehicle Deposit & Tow Fee' and the other is 'DPMO Payment' what I am trying to achieve is that within the matches formula to string the two answers together as one so results being 'Vehicle Deposit & Tow Fee, DPMO Payment'

Many Thanks

Danny

**Glenn Kennedy** · 04-02-2015, 03:57 AM

Yes you can. Here's one way originally (using a UDF) developed by anoher user (TigerAvatar), which I think that you'll be able to adapt.

**gassiusmax** · 04-02-2015, 08:38 AM

Thanks for that its a handy one to know, but for now I can not seem to modify it into the formula I use

=INDEX(DEDUCTIONS!$B$5:$E$43,MATCH(1,(DEDUCTIONS!$B$5:$B$43=B26)*(DEDUCTIONS!$C$5:$C$43='PAYMENT SUMMARY'!$C$6),0),4)

**Glenn Kennedy** · 04-02-2015, 12:22 PM

OK. I came back to this and think/hope/pray that this is/might be what you want.

In you post, you highlighted two instances for Marius Ciuta, where you wanted both reasons to appear. They will, but only if the date range in Work Summary C3 & C4 includes 3/4/15. Is this what you had wanted, or am I misunderstanding the relationship between the date range on "work summary" and the "Date due to take" on the deductions sheet???