| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
