Need Formula to find worksheet

[TJF]

I need a formula to check the name in cell C12 and then find the worksheet with the same name(there are only 4 names to check). Once found cells C13 & C14 need to be pasted in the found worksheet in cells E5 & E6.

[Jezebel]

IN one cell, construct the address of the cell you want to reference; then
in the target cell use the Indirect() function -- eg

C12 contains the name of the sheet you want: eg "DataSheet"
D12 might contain this formula: "[" & C12 & "]!C13" Result =
[DataSheet]!C13
E5 contains formula: =Indirect(D12)




"TJF" <TJF.1z4xum_1133061000.9169@excelforum-nospam.com> wrote in message
news:TJF.1z4xum_1133061000.9169@excelforum-nospam.com...
>
> I need a formula to check the name in cell C12 and then find
> the worksheet with the same name(there are only 4 names to check). Once
> found cells C13 & C14 need to be pasted in the found worksheet in cells
> E5 & E6.
>
>
> --
> TJF
> ------------------------------------------------------------------------
> TJF's Profile:
> http://www.excelforum.com/member.php...o&userid=29096
> View this thread: http://www.excelforum.com/showthread...hreadid=488432
>