Vlookup? I am sure the solution is here

**jlfrancis2001** · 07-15-2012, 11:03 PM

id skill
1 carpenter
1 phone
1 lead
3 phone
3 data
4 carpenter
4 electrician
5 data
5 phone
5 electrician

I need
1 carpenter ; phone ; lead
3 phone ; data

**vlady** · 07-16-2012, 01:28 AM

hello welcome to the forum...

steps.
Right click on the sheet tab - choose "view code"
on the windows that will appear -go to main menu - Insert - then choose "module"
Then paste the code on that window.
Finish.

Please Login or Register  to view this content.

use
E2 is 1

=vlookmulti(E2,A:B,2)

**olasa** · 07-16-2012, 09:51 AM

Just in case. This was a fairly similar problem
http://www.excelforum.com/showthread...=1#post2852229
//Ola

...works fine. I just tested, in cell
D2: 1
E2: =StringConcat("; ";IF($A$2:$A$12=$D2;$B$2:$B$12;""))
confirmed with Ctrl+Shift+Enter, not just Enter