Revision history [back]

calc - filename from cell

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?

calc - filename from cell

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?

calc - filename from cell

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 erAck 4198 ●29 ●49 https://erack.de/

calc - filename from cell

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?