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" wrote in message
...
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?