N
NirOrtal
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
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