Need One Dropdown List to Kick off Another

[Xbwalker]

Hello folks! This is my first post here so.. hello.

Anyhow, I am trying to create an excel formula that allows me to open up a second list once certain conditions are met in the first list. I am attempting to create a document that shows ports as "occupied" once I have them selected. However, I can not figure out how to get the ports for the specific switches I select to show up once I select the switch in the dropdown list. Take a look and tell me what you think. Thanks!

I am running Excel 2013 by the way. See attached doc.

[FDibbins]

Hi, welcome to the forum

could you show some sample answers please, that way, we know what you are looking for

[Xbwalker]

Sure thing. Here is a pic. switchpic.jpg

[Xbwalker]

To add to my pic. I would like the dropdown list that appears under "Destination Port" to contain the numbers to the right of whatever switch I chose in the column before.

[oeldere]

with define names

define the name

excel 2013 => formula => define name

after that use datavalidation

excel 2013 => data => datavalidation => list

celll d2 = =INDIRECT($C2)

see the attached file.

[Xbwalker]

Aha! I knew define name had something to do with it. I just didn't know the indirect command.

Ok, I defined rows 3 and 4 as well and tested it out. My next question is, how can I make it so, when I select a port number, that corresponding port to the right changes to "bad" (Red cell)?

[oeldere]

I don't see that information ("bad") in yor example.