| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
| How do I total range of cells that have checks in checkboxes? | Excel Discussion (Misc queries) | |||
| UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) | |||
| how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
| Merging Cells but have each cell counted in the range of merged c. | Excel Worksheet Functions | |||
Linear Mode
