Can a cell refer to a Range of cells?

G

Guest

When I have 'Germany' in such cell I want a formula that transforms it into
"GERVar" that is range of cells. When another formula (INDEX formula) goes to
that cell, it would see the content of that cell as "GERVar"=Range of cells
and not text only.

Can you help?

Anne de Courreges
 
R

Roger Govier

Hi Anne

Create a named range called Germany.
Insert>Name>Define>Name>Germany >Refers to your_range

With cell A1 containing the word Germany
=INDEX(INDIRECT(A1),3,1) will give the third row of the first column of
the range you defined as Germany.
 
G

Guest

Thank you so much! You are my Excel savor!
You made my day shinning!

-
Anne de Courreges
 

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

Selecting range in list of range names depending on a cell informa 2
Can a cell refer to range name/array of data previously set? 1
Clearing content from a cell (or a group) but retain its formula 2
Copying A Range of Cells to Another Worksheet 3
Formula to return the reference of a range of cells 4
Range Expression 2
Refer to adjacent cells as variables in formula 4
Conditional Formatting Based on Colors in a Horz Range of Cells 10

Top