Combo Box & value reference

[deepak]

Hi!
I have a small problem with displaying values.

In sheet2
A B C D
E F
1 ControlPanel 4 Zone 6 Zone 8 Zone 12 Zone 16 Zone
2 74 98 118 130 150
3 StandByBattery 12V_1.3AH 12V_7AH
4 8 10

I am able to have dropdown menu in sheet 1 for contorlPanel and
StandByBattery in A1, and also the a dropdown menu in B1 whose value changes
as per A1. E.g. if I select ControlPanel in A1, the values in B1 will be 4
Zone, 6 Zone..... in dropdown menu.

How can I do - Suppose if I select 4 Zone from the dropdown menu of B1, the
value of C1 should be 74, and if I select 16 Zone, the value of C1 should be
150 automatically.

Your help will be much appreciated.
Thank you

 

[sidm via OfficeKB.com]

Hi!
I have a small problem with displaying values.

In sheet2
A B C D
E F
1 ControlPanel 4 Zone 6 Zone 8 Zone 12 Zone 16 Zone
2 74 98 118 130 150
3 StandByBattery 12V_1.3AH 12V_7AH
4 8 10

I am able to have dropdown menu in sheet 1 for contorlPanel and
StandByBattery in A1, and also the a dropdown menu in B1 whose value changes
as per A1. E.g. if I select ControlPanel in A1, the values in B1 will be 4
Zone, 6 Zone..... in dropdown menu.

How can I do - Suppose if I select 4 Zone from the dropdown menu of B1, the
value of C1 should be 74, and if I select 16 Zone, the value of C1 should be
150 automatically.

Your help will be much appreciated.
Thank you

Hi
Select the Main Control Panel and the Zone the have a VLookup for the value
in C1 based on your data..