Which formula to use and how

I manage excel workbooks regarding our networks.
The lists all the devices that are connected to what ports on the switches and in what VLANs they are in.

I am trying to automate the bottom section of the worksheet, labeled "SHOW VLAN".
If you run this command on a switch, it will give me the data I want.
But when you paste it into a text document, then import into Excel, it gets sloppy. The data gets chopped off.
Also, it means you'd have to run the command, export, and import EVERY TIME there is a change.
So i figure it's better to automate it from the data already given.

I've tried VLOOKUP, VLOOKUP RANGE, INDEX, MATCH.
They all give me errors.
I am either not using it correctly and/or using the wrong function.
I've done much research on google and youtube.

Here's what I need to accomplish...
Given the data from Column E, I need to return the MULTIPLE values of data in Column C.
Example, under the 1st Row of "SHOW VLAN" section, you see "1" and "Default" as the 1st VLAN.
The value returned needs to specify the MULTIPLE ports that are in VLAN "1".
Therefore, it should return ports "1/0/14" & "1/0/15" in my attached example.

How can I accomplish this?

Thanks for the help!
Off to a good start, but the data in "Dept/User" column is not always going to match the VLAN Name.

See my new attachment (Port 16) as an example.
Let's say the connection is located in the "Gym", but the person using this line is still part of "Staff".

I would want them to still show up under the "Staff" VLAN.
The words "Staff", "wap", "printer", etc. at bottom of sheet would be manually entered.

is there a way I can use just C39 formula without referencing the B39 formula?

OR I could just reference the value in Column E instead of the value in Column B.
That way it will always stay the same.

Just to clean things up a bit, is there any way to have it automatically put the returned values on multiple Rows instead of just 1 row??
Lets say 5 or 10 ports per row. That would look a bit more organized.