 | 1 | initial version |
Let's say I have sheets "myStuff_10", "myStuff_30", ... imported
on the A column, I have
10
30
50
70
...
and in the C column, I want to have
='myStuff_10'.$B$5
='myStuff_30'.$B$5
...
How can I take that value from the A column, though?
I.e.
='myStuff_<take from A column>'.$B$5
='myStuff_<take from A column>'.$B$5
...
such that I can drag it down rather than manually adjust a thousand cells?
Let's say I have sheets "myStuff_10", "myStuff_30", ... imported
on the A column, I have
10
30
50
70
...
and in the C column, I want to have
='myStuff_10'.$B$5
='myStuff_30'.$B$5
...
How can I take that value from the A column, though?
I.e.
='myStuff_<take from A column>'.$B$5
='myStuff_<take from A column>'.$B$5
...
something like (doesn't work, ERR:501)
=INDIRECT("myStuff_"&A3).$B$5
such that I can drag it down rather than manually adjust a thousand cells?
Let's say I have sheets "myStuff_10", "myStuff_30", ... imported
on the A column, I have
10
30
50
70
...
and in the C column, I want to have
='myStuff_10'.$B$5
='myStuff_30'.$B$5
...
How can I take that value from the A column, though?
I.e.
='myStuff_<take from A column>'.$B$5
='myStuff_<take from A column>'.$B$5
...
something like (doesn't work, ERR:501)ERR:501):
=INDIRECT("myStuff_"&A3).$B$5
such that I can drag it down rather than manually adjust a thousand cells?
| | 4 | retagged |
Let's say I have sheets "myStuff_10", "myStuff_30", ... imported
on the A column, I have
10
30
50
70
...
and in the C column, I want to have
='myStuff_10'.$B$5
='myStuff_30'.$B$5
...
How can I take that value from the A column, though?
I.e.
='myStuff_<take from A column>'.$B$5
='myStuff_<take from A column>'.$B$5
...
something like (doesn't work, ERR:501):
=INDIRECT("myStuff_"&A3).$B$5
such that I can drag it down rather than manually adjust a thousand cells?
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.