Formulae using range names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi Wendy,
This worked for me with text typed into C1 and D11
=INDIRECT(C11) INDIRECT(D11)
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using named ranges in a formula 3
Dependent drop down dynamic range formula, off sheet. 7
Sum every Nth Row (almost working) 1
a data validation list that contains a list of named ranges - not alist from a named range 1
Go To a Named Range (2nd posting) 4
A find formul looking at two named ranges for two strings 6
Drop Down with dynamic named range offsheet source list 14
Question on Named range with formula 2

Back
Top