Can a cell refer to a Range of cells?

C

Courreges

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.
 
C

Courreges

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
Copy addition formula of non-consecutive horizontal cells 2
Excel does not accept text format! 0
Can a cell refer to range name/array of data previously set? 1
Excel - Wich Function should I use? 1
Pasting a cell into bookmarked table from excel vba 1
Merging from an Excel file with graphics 1
need help in fine-tuning a formula that removes blank cells in a column range 3

Top