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

[Snorkster]

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



"Snorkster" <[email protected]> wrote in message
news:[email protected]...
>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?