Can a cell refer to a Range of cells?
 

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

Can a cell refer to a Range of cells?
 

See reply to your ealier posting.

"Courreges" wrote:

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

Can a cell refer to a Range of cells?
 

Hi Anne

Create a named range called Germany.
InsertNameDefineNameGermany 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.

--
Regards

Roger Govier


"Courreges" wrote in message
...
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

Can a cell refer to a Range of cells?
 

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

-
Anne de Courreges


"Toppers" wrote:

See reply to your ealier posting.

"Courreges" wrote:

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