Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Formula to find worksheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
FIND FORMULA SIMILAR TO VLOOKUP FOR NON-ASCENDING VALUES | Excel Worksheet Functions | |||
Find and delete part of formula for multiple formulas? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |