ExcelBanter - Can a sheet be referenced by a value in a cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Can a sheet be referenced by a value in a cell? (https://www.excelbanter.com/excel-worksheet-functions/130998-can-sheet-referenced-value-cell.html)

Reddiance

Can a sheet be referenced by a value in a cell?

If I'm in sheet "Main" and the value of A1 is "DEV",
is there way to reference the DEV sheet by the value that is in a cell, in
this case the value in A1?

For example, in sheet "Main"
A1 has "DEV",
in cell A2, I do something like =Valueof(A1)!D13
I'd like to reference cell D13 in sheet "DEV", but I don't want to hard-code
"DEV" or any other value in A1.

Can this be done?

Thanks

Teethless mama

Can a sheet be referenced by a value in a cell?

=INDIRECT("'"&A1&"'!D13")

"Reddiance" wrote:

If I'm in sheet "Main" and the value of A1 is "DEV",
is there way to reference the DEV sheet by the value that is in a cell, in
this case the value in A1?

For example, in sheet "Main"
A1 has "DEV",
in cell A2, I do something like =Valueof(A1)!D13
I'd like to reference cell D13 in sheet "DEV", but I don't want to hard-code
"DEV" or any other value in A1.

Can this be done?

Thanks

All times are GMT +1. The time now is 05:21 PM.