Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formulae using range names
I've used a formula (= Possible Major) which uses range names to return the
intersect of two named ranges, where Possible is one named range and Major is another. This works fine if I type the formula in directly but I want to return the value from the cell references instead i.e. I have two drop downs for data validation so the user can select Possible in column C and Major in column D. I am therefore trying to use =C11 D11 which I hoped would be 'translated' to =Possible Major and therefore give me the correct answer as if typed in manually. Does anyone know if it is possible to do this. Thanks. |
#2
|
|||
|
|||
Hi Wendy,
This worked for me with text typed into C1 and D11 =INDIRECT(C11) INDIRECT(D11) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Wendy" wrote in message ... I've used a formula (= Possible Major) which uses range names to return the intersect of two named ranges, where Possible is one named range and Major is another. This works fine if I type the formula in directly but I want to return the value from the cell references instead i.e. I have two drop downs for data validation so the user can select Possible in column C and Major in column D. I am therefore trying to use =C11 D11 which I hoped would be 'translated' to =Possible Major and therefore give me the correct answer as if typed in manually. Does anyone know if it is possible to do this. Thanks. |
#3
|
|||
|
|||
Wendy - try this formula
=INDIRECT(c11) INDIRECT(d11) "Wendy" wrote: I've used a formula (= Possible Major) which uses range names to return the intersect of two named ranges, where Possible is one named range and Major is another. This works fine if I type the formula in directly but I want to return the value from the cell references instead i.e. I have two drop downs for data validation so the user can select Possible in column C and Major in column D. I am therefore trying to use =C11 D11 which I hoped would be 'translated' to =Possible Major and therefore give me the correct answer as if typed in manually. Does anyone know if it is possible to do this. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Range Names | Excel Discussion (Misc queries) | |||
Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) | |||
range names | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions |