VLookup on a Cell has multiple values

yes that can be done you need to use VBA for that first copy paste first code below
http://www.excelforum.com/tips-and-t...geravatar.html

then use copy paste below formula in G3 then hold control and shift together and then hit enter to make it array formula
=ConcatAll(TRIM(IF($A$2:$A$5=TRANSPOSE(TRIM(MID(SUBSTITUTE(","&$E3,",",REPT(" ",255)),255*(ROW(INDIRECT("1:"&LEN($E3)-LEN(SUBSTITUTE($E3,",",""))+1))),255))),$B$2:$B$5,"")),CHAR(10))

select the cell with your formula the press F2 key, Now hold control and shift together and then hit enter to make it array formula.

I notice that the file you uploaded indicates 2007 or later (.xlsx), but your profile says 2003. Please update your profile as necessary, members tailor questions based on your excel version

can you please show a sample book.

copy first code from below link
http://www.excelforum.com/tips-and-t...geravatar.html
then open your excel file, Press Alt + F11 --> this will open VB Editor---> at the top click Insert--> click module. Paste the code here, Then in your workbook.
use below formula.

=ConcatAll(TRIM(IF(TRIM($B$2:$B$2931)=TRANSPOSE(TRIM(MID(SUBSTITUTE(","&$D2,",",REPT(" ",255)),255*(ROW(INDIRECT("1:"&LEN($D2)-LEN(SUBSTITUTE($D2,",",""))+1))),255))),$C$2:$C$2931,"")),CHAR(10)) and Drag down.

You are welcome.

what sort of outlining you are looking for. When you use any VBA code you need to save file as macro enabled workbook.

select A2 to A3000, go to conditional formatting ---> click new rule--->select use a formula to determine which cells to format.

In formula box copy paste below =NOT(ISNUMBER(RIGHT(TRIM($B2),1)+0))

then click the format option at the bottom --> go to FILL Tab select the desired color click OK.

You need to use VBA for the same. I suggest you to start a new thread in the VBA Questions. Moreover if your actual query with this thread is solved then you can mark thread as solved.