Hi, Need help with returning multiple values into single cell

The thing you want to achieve can be done through VBA, Follow the Link Below
http://www.excelforum.com/tips-and-t...geravatar.html

after copying and pasting code in your workbook Use an If function with above function to get the results i.e. in E2 copy paste below
=ConcatAll(IF($A$3:$A$14=D3,$B$3:$B$14,""),",") then hold control and shift then hit enter and drag down

Originally Posted by sam189

Hi This is my first post. I have a query, basically I need to return multiple values into a single cell. From the data below I need the employees belong to one Cost Centre and I need to enter the employee numbers in one cell as shown below. Please advise if I can use Vlookup and Concatanate to fix this and I am not a VBA user.

Thank You

Samuel

1950/1 14080, 22388, 14097, 14099



Cost Centre Emp No
1950/1 14080
1950/1 22388
1950/1 14097
1950/1 14099
1950/1 14108
1950/1 14112
1950/1 14115
1950/1 14116
1950/1 14117

Hi Sam,

In the attached workbook I've used the same example table you used but instead of manually entering the answers there is now a UDF to automatically generate the answers.

There is a macro running on this sheet as it is a user defined formula.

Give me a message if you need any more help.

If this helped could you please Add to my Reputation?

Thanks.