Need Formula to find worksheet

  • Thread starter Thread starter TJF
  • Start date Start date
T

TJF

:confused: I need a formula to check the name in cell C12 and then fin
the worksheet with the same name(there are only 4 names to check). Onc
found cells C13 & C14 need to be pasted in the found worksheet in cell
E5 & E6
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to copy a formula to a 100 cells 3
Need Formula to find worksheet 2
PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1
copy formulas to different cells in another worksheet 1
The specified formula cannot be entered because it uses more levels of nesting than are allowed in t 7
Vlookup Reference Certain Worksheets 4
How do I say… 11
Countifs anchoring formula when sorting 1

Back
Top