| 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 |
| 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 | |||
Threaded Mode
