Need Formula to find worksheet
 

:confused: 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

Need Formula to find worksheet
 

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

:confused: 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