Related drop down lists
 

Hi

Im working with Excel 2007

I have 2 lists. In column A I have components and in column B I have
companies.

A B
Memory Dell
CPU IBM
Board IBM
Power Supply Dell

I have drop down list in F2 that contain the B column list (companies).

1. I want to create in F3 another drop down list that related to F2.
Example €“ if I choose Dell in F2, I want to see in F3 €˜memory & €˜Power
Supply option only
2. How can I avoid duplication in the F2 drop down list?
3. Do I need to use the LOOKUP functions?

Thanx

Related drop down lists
 

Debra Dalgleish has some notes he

http://www.contextures.com/xlDataVal02.html

on dependent Data Validation, which is what you want to do.

Hope this helps.

Pete

On Nov 13, 11:38*pm, NirOrtal
wrote:
Hi

I’m working with Excel 2007

I have 2 lists. In column A I have components and in column B I have
companies.

* A * * * * * * * * * * * * * *B
Memory * * * * * * * * *Dell
CPU * * * * * * * * * * * *IBM
Board * * * * * * * * * * IBM
Power Supply * * * * *Dell

I have drop down list in F2 that contain the B column list (companies).

1. * * *I want to create in F3 another drop down list that related to F2.
Example – if I choose Dell in F2, I want to see in F3 ‘memory’ & ‘Power
Supply’ option only
2. * * *How can I avoid duplication in the F2 drop down list?
3. * * *Do I need to use the LOOKUP functions?

Thanx

Related drop down lists
 

Hi

You need to create 3 lists
List1 is the name of the companies , Dell, IBM etc.
Dell is Memory, Power Supply etc.
IBM is CPU, Board etc.

In the first validation cell, e.g. A1 set the validation to be List =List1
In the second validation cell set the validation to be List =INDIRECT(A1)

For more help on Validation take a look at
http://www.contextures.com/xlDataVal02.html
--
Regards
Roger Govier

"NirOrtal" wrote in message
...
Hi

Im working with Excel 2007

I have 2 lists. In column A I have components and in column B I have
companies.

A B
Memory Dell
CPU IBM
Board IBM
Power Supply Dell

I have drop down list in F2 that contain the B column list (companies).

1. I want to create in F3 another drop down list that related to F2.
Example €“ if I choose Dell in F2, I want to see in F3 €˜memory & €˜Power
Supply option only
2. How can I avoid duplication in the F2 drop down list?
3. Do I need to use the LOOKUP functions?

Thanx

Related drop down lists
 

hi

what do you mean "Dell is Memory, Power Supply"?

"Roger Govier" wrote:

Hi

You need to create 3 lists
List1 is the name of the companies , Dell, IBM etc.
Dell is Memory, Power Supply etc.
IBM is CPU, Board etc.

In the first validation cell, e.g. A1 set the validation to be List =List1
In the second validation cell set the validation to be List =INDIRECT(A1)

For more help on Validation take a look at
http://www.contextures.com/xlDataVal02.html
--
Regards
Roger Govier

"NirOrtal" wrote in message
...
Hi

Im working with Excel 2007

I have 2 lists. In column A I have components and in column B I have
companies.

A B
Memory Dell
CPU IBM
Board IBM
Power Supply Dell

I have drop down list in F2 that contain the B column list (companies).

1. I want to create in F3 another drop down list that related to F2.
Example €“ if I choose Dell in F2, I want to see in F3 €˜memory & €˜Power
Supply option only
2. How can I avoid duplication in the F2 drop down list?
3. Do I need to use the LOOKUP functions?

Thanx

Related drop down lists
 

I mean create a list called Dell, which contains Memory and Power Supply.
Create a List called IBM which contains CPU and Board.

Did you check out the link I gave you?
That will show you clearly what you need to do.

--
Regards
Roger Govier

"NirOrtal" wrote in message
...
hi

what do you mean "Dell is Memory, Power Supply"?

"Roger Govier" wrote:

Hi

You need to create 3 lists
List1 is the name of the companies , Dell, IBM etc.
Dell is Memory, Power Supply etc.
IBM is CPU, Board etc.

In the first validation cell, e.g. A1 set the validation to be List
=List1
In the second validation cell set the validation to be List
=INDIRECT(A1)

For more help on Validation take a look at
http://www.contextures.com/xlDataVal02.html
--
Regards
Roger Govier

"NirOrtal" wrote in message
...
Hi

Im working with Excel 2007

I have 2 lists. In column A I have components and in column B I have
companies.

A B
Memory Dell
CPU IBM
Board IBM
Power Supply Dell

I have drop down list in F2 that contain the B column list (companies).

1. I want to create in F3 another drop down list that related to F2.
Example €“ if I choose Dell in F2, I want to see in F3 €˜memory & €˜Power
Supply option only
2. How can I avoid duplication in the F2 drop down list?
3. Do I need to use the LOOKUP functions?

Thanx

Related drop down lists
 

thanx
2. how can i avoid duplication in F2?

"Roger Govier" wrote:

I mean create a list called Dell, which contains Memory and Power Supply.
Create a List called IBM which contains CPU and Board.

Did you check out the link I gave you?
That will show you clearly what you need to do.

--
Regards
Roger Govier

"NirOrtal" wrote in message
...
hi

what do you mean "Dell is Memory, Power Supply"?

"Roger Govier" wrote:

Hi

You need to create 3 lists
List1 is the name of the companies , Dell, IBM etc.
Dell is Memory, Power Supply etc.
IBM is CPU, Board etc.

In the first validation cell, e.g. A1 set the validation to be List
=List1
In the second validation cell set the validation to be List
=INDIRECT(A1)

For more help on Validation take a look at
http://www.contextures.com/xlDataVal02.html
--
Regards
Roger Govier

"NirOrtal" wrote in message
...
Hi

Im working with Excel 2007

I have 2 lists. In column A I have components and in column B I have
companies.

A B
Memory Dell
CPU IBM
Board IBM
Power Supply Dell

I have drop down list in F2 that contain the B column list (companies).

1. I want to create in F3 another drop down list that related to F2.
Example €“ if I choose Dell in F2, I want to see in F3 €˜memory & €˜Power
Supply option only
2. How can I avoid duplication in the F2 drop down list?
3. Do I need to use the LOOKUP functions?

Thanx