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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and return sheet name also 2
Concatenate path and file string for external reference 4
Refer to a sheet using a cell value 2
reference work sheet name by using a formula 3
Referencing formula using Indirect 4
subtract 2 cells and get blank instead of 0.0 3
Scrabble Value calculation for Welsh words 0
using the address referenced in a linked cells 10

Back
Top