data validation, vlookup or what??

dvirgil

New Member
Joined
May 6, 2008
Messages
10
I have a cost estimation spreadsheet. I have cell A6 pull data validation name list of hardware from another sheet. Then I have cell B6 pull data vlaidation name list of software from another sheet. Then they calculate into another cell and it works wonderful. What I am trying to do now is, once they pull a hardware selection from A6 drop down list, I want only the options that may go with that selection to appear for cell B6.

For instance:
A6 selects Large Sun Server

I want B6 to only display the support that goes with a Large Sun Server box, and not pull the entire name list in the validation.

I'm not sure what formula i need, or if i need to get rid of my data vlaidation name lists or what i can do. Like i said it works great now, but looking to improve and help guide the end user with right choices
 

Domski

Well-known Member
Joined
Jan 18, 2005
Messages
7,292
Hi,

Try doing a search for Cascading Data Validation, I reckon it should help.

Dom
 

Forum statistics

Threads
1,082,570
Messages
5,366,364
Members
400,886
Latest member
Fchel

Some videos you may like

This Week's Hot Topics

Top