Reference another sheet, but with cell value as name

[chulho]

hi,

is there a way to reference another sheet with value from another cell?

so instead of typing out the sheet name in formula, i.e. =sheet1A1, i want to "sheet1" to be dynamic- chosen from a drop down menu, let's say value in c2.

of course a simple =c2!A1 would not work because that would just try to find a sheet named "c2", which doesn't exist.

please see attached file.

thanks for having a look

-cc

[Olly]

Please Login or Register  to view this content.

[chulho]

nice! just "got" indirect.

this works perfectly. thanks!!