Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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?

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?