| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use concatenated text as name in formulas
Here is my problem,
I am trying to return a cell value using a cell name as a result of the concatenation of two fields. Example: Sheet A has a cell named P1_1 which contains a value. In Sheet B I am concatenating cell A1 (P1) with cell B1 (1) as follows: =concatenate("+",A1,"_",B1). Excel inserts "+P1_1" into the cell where I inserted the formula i.e. Excel inserts a string of text. I would like the value of the cell named P1_1 to be inserted instead. Any clues out there on how to achieve this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use concatenated text as name in formulas
=INDIRECT(A1&"_"&B1)
HTH -- AP "Apollo63" a écrit dans le message de news: ... Here is my problem, I am trying to return a cell value using a cell name as a result of the concatenation of two fields. Example: Sheet A has a cell named P1_1 which contains a value. In Sheet B I am concatenating cell A1 (P1) with cell B1 (1) as follows: =concatenate("+",A1,"_",B1). Excel inserts "+P1_1" into the cell where I inserted the formula i.e. Excel inserts a string of text. I would like the value of the cell named P1_1 to be inserted instead. Any clues out there on how to achieve this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use concatenated text as name in formulas
Thanks. Works perfectly.
Ardus Petus schrieb: =INDIRECT(A1&"_"&B1) HTH -- AP "Apollo63" a écrit dans le message de news: ... Here is my problem, I am trying to return a cell value using a cell name as a result of the concatenation of two fields. Example: Sheet A has a cell named P1_1 which contains a value. In Sheet B I am concatenating cell A1 (P1) with cell B1 (1) as follows: =concatenate("+",A1,"_",B1). Excel inserts "+P1_1" into the cell where I inserted the formula i.e. Excel inserts a string of text. I would like the value of the cell named P1_1 to be inserted instead. Any clues out there on how to achieve this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
| HOW DO I CORRECT A CONDITION IN WHICH ALL FORMULAS ACT LIKE TEXT? | Excel Worksheet Functions | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| How do you average text formulas?? | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
