Can a cell refer to range name/array of data previously set?

C

Courreges

I need a formula that looks in the the right range when the cell gets such a
value
For example, if I select in a country list 'Germany', the match formula will
look for the right value in the array 'GERVar', if I pick up 'UK', the match
formula will look for the value in the range 'UKVar', etc...

Hope I am clear enough!

Thanks for your help.
 
P

Paul Lautman

Courreges said:
I need a formula that looks in the the right range when the cell gets
such a value
For example, if I select in a country list 'Germany', the match
formula will look for the right value in the array 'GERVar', if I
pick up 'UK', the match formula will look for the value in the range
'UKVar', etc...

Hope I am clear enough!

Thanks for your help.
Click to expand...

What do you want it to do once it has looked up the match?
 

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

Word macro that can call cells out of Excel for a find and replace 0
Selecting range in list of range names depending on a cell informa 2
need help in fine-tuning a formula that removes blank cells in a column range 3
Can a cell refer to a Range of cells? 3
Referencing a named array 1
Saving a range for later reference 0
Cell reference in formula as range 4
Finding the right style field in VBA 0

Top