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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Snorkster - 11 Sep 2005 20:42 GMT

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?

Reply to this Message

KL - 11 Sep 2005 21:28 GMT

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

>i want to be able to look for a worksheet that matches a name in a given
>cell?
[quoted text clipped - 3 lines]
> so
> that i can use multiple sheets for a work training matrix?

Reply to this Message