| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell data format | Excel Discussion (Misc queries) | |||
| Summed Cell won't update as I add data into the cell range... | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| highlight range if cell contains desired data | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
