Can a cell refer to a Range of cells?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 

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
VBA set thick borders around non empty cells in range 0
Count cells in a range 2
Clearing content from a cell (or a group) but retain its formula 2
Formula to return the reference of a range of cells 4
Cell reference in formula as range 4
Invalid cell reference 1

Back
Top