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

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.

--
Anne de Courreges

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

Courreges wrote:
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.

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