Excel Help

[JohnnyO]

I am not sure if it can be done, but the Validation list would have to include some kind of vlookup. Or an if then else command.

[Buff]

Originally Posted by fotze

Is it possible to make smart drop down lists? I want the drop down list to change depending what is entered to the cell to the left of it.

I am trying to use the data validation, but can't get it to go beyond the simple drop down list.

Is this possible without going into some macro programming bidness?

Sounds a bit complicated what you're trying to do. I would imagine if you're going to do it in excel that you'd probably have to get into that macro programming bidness. I'm no excel expert though, people come to my company when they want something too complicated for Excel.

[Eagle Eye]

I would use a vlookup pointing to a table in another tab.

Something simple like this

[Bring_Back_Shantz]

I'm not 100% sure what it is you want to do.

Do you want the whole list to change based on what is in the cell?
or
Do you want what is selectedin the dropdown box to change based on what is in the cell.

if it is the later, then all you have to do is set the linked cell (in the dropdown box properties) to that cell and as long as it's in the list it'll show up in the dropdown box.

If you want to change the whole list, you can still do it.
Set the link fill range to a certain set of cells, and then fill that range with what you need using something like this

=Vlookup(1,indirect(cell next to dropdown box),2,0)

You'll have to make all of the lists in that you want to show up in your dropdown box as named arrays that look like this

1 item 1
2 item 2
3 item 3

PM me your email address if you want a quick example.

NM it works just fine.

[Eagle Eye]

Ahh I see what you are saying.

Sorry misread your post

yup that would return the first value from a list

Try this I used a nested if statement in the drop down list setup

I named the first list "team" the second list "Type' and the third list "number"

Depending on the value I select in Column F (a list) I will get a different list to pick from

[Eagle Eye]

Here is what I can pick from if I select 2



Here is what I can pick from if I select 1