Vlookup with Multiple Results in same cell?

[mick0005]

I am trying to take data input like this:

With a formula to output it like this:

Is this possible??

THANKS! This would save hours of work every week.

 

[Marcelo Branco]

The count is in Column W, isnt it?

M.

 

[mick0005]

The count is in Column W, isnt it?

M.

Yes that is correct, Column W. (It is actually in column W on another sheet than the one I am putting the output formula on, but I got the formula to work by just changing your reference to the other sheet in the formula)

 

[Marcelo Branco]

Try this formula
=SUBSTITUTE(ACONCAT(IF($U$2:$U$9=A2,IF($W$2:$W$9<>"","; "&$V$2:$V$9&"("&$W$2:$W$9&")",""),"")),"; ","",1)

Ctrl+Shift+Enter

copy down

HTH

M.

 

[mick0005]

Try this formula
=SUBSTITUTE(ACONCAT(IF($U$2:$U$9=A2,IF($W$2:$W$9<>"","; "&$V$2:$V$9&"("&$W$2:$W$9&")",""),"")),"; ","",1)

Ctrl+Shift+Enter

copy down

HTH

M.

OUTSTANDING! You are amazing! Thank you!

 

[Marcelo Branco]

OUTSTANDING! You are amazing! Thank you!

You are welcome

Glad to help

M.