=(A6)!$O$14 - why won't this look for same name sheet as A6?

[Guest]

i want to be able to look for a worksheet that matches a name in a given cell?

Examlpe - the text in cell A6 is master, so i want to look for the sheet
called master so that i can look for specific cells in that sheet. This is so
that i can use multiple sheets for a work training matrix?

 

[KL]

Hi Snorkster,

Try this:

=INDIRECT(A6&"!$O$14")

or if the cell reference on the target sheet has to be relative then:

=INDIRECT(A6&"!"&CELL("address",O14))

Regards,
KL