Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can we formular a dynamic cell? i.e. =B2 as ="B"&"2"??
Here is what I would like to have:
A B 1 B 2 10 Setup a value 'B' in cell A1 and hope to get B2 value "10" in cell A2 - thought that using ="A1"&2 in cell A2 will work but didn't..... /QAtest |
#2
|
|||
|
|||
=INDIRECT(A1&ROW())
-- HTH Bob Phillips "qatest" wrote in message ... Here is what I would like to have: A B 1 B 2 10 Setup a value 'B' in cell A1 and hope to get B2 value "10" in cell A2 - thought that using ="A1"&2 in cell A2 will work but didn't..... /QAtest |
#3
|
|||
|
|||
If I understand your question correctly, A2 should contain the following
=INDIRECT(A1&2) "qatest" wrote: Here is what I would like to have: A B 1 B 2 10 Setup a value 'B' in cell A1 and hope to get B2 value "10" in cell A2 - thought that using ="A1"&2 in cell A2 will work but didn't..... /QAtest |
#4
|
|||
|
|||
have a look in HELP index for INDIRECT
-- Don Guillett SalesAid Software "qatest" wrote in message ... Here is what I would like to have: A B 1 B 2 10 Setup a value 'B' in cell A1 and hope to get B2 value "10" in cell A2 - thought that using ="A1"&2 in cell A2 will work but didn't..... /QAtest |
#5
|
|||
|
|||
How did that happen? I looked earlier and yours was the only response. Now I
look, and my is time-stamped earlier than yours. I have noticed that Mangesh's all get at the top of the list, regardless of whether he is first responder or not, now it is happening to me :-) Bob "Duke Carey" wrote in message ... If I understand your question correctly, A2 should contain the following =INDIRECT(A1&2) "qatest" wrote: Here is what I would like to have: A B 1 B 2 10 Setup a value 'B' in cell A1 and hope to get B2 value "10" in cell A2 - thought that using ="A1"&2 in cell A2 will work but didn't..... /QAtest |
#6
|
|||
|
|||
Bob -
Must be your newsreader. I'm able to use only the Microsoft web interface while at the office. In that view, your post shows up at 10:30, lower on the screen than mine at 10:26. Duke "Bob Phillips" wrote: How did that happen? I looked earlier and yours was the only response. Now I look, and my is time-stamped earlier than yours. I have noticed that Mangesh's all get at the top of the list, regardless of whether he is first responder or not, now it is happening to me :-) Bob "Duke Carey" wrote in message ... If I understand your question correctly, A2 should contain the following =INDIRECT(A1&2) "qatest" wrote: Here is what I would like to have: A B 1 B 2 10 Setup a value 'B' in cell A1 and hope to get B2 value "10" in cell A2 - thought that using ="A1"&2 in cell A2 will work but didn't..... /QAtest |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamic external cell reference | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |