Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data validation
Hi,
I have a problem with data validation. My validation is dependant on two seperate cells. I have created two lists, the first is a list of beam types, the second is a list of beam sizes. Now what i want to be able to do is allow the user to select a beam type and then select a beam size and have the correct cross sectional area appear in a seperate cell. Can anyone give me a formula to allow me to do this? Thanks in advance! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data validation
"Blades" wrote:
I have a problem with data validation. My validation is dependent on two seperate cells. I have created two lists, the first is a list of beam types, the second is a list of beam sizes. Now what i want to be able to do is allow the user to select a beam type and then select a beam size and have the correct cross sectional area appear in a seperate cell. Can anyone give me a formula to allow me to do this? Assuming the DV for Beam_Size is in A1, DV for Beam_Type in B1 Then something like this in C1, array-entered i.e. press CTRL+SHIFT+ENTER to confirm the formula: =INDEX(Beam_CrossSectArea,match(1,(Beam_Size=A1)*( Beam_Type=B1),0)) The 3 defined names: Beam_Size Beam_Type Beam_CrossSectArea are assumed identically sized ranges -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
existing data in case of data validation | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |