Worksheet from Formula

  • Thread starter Thread starter Scott Morton
  • Start date Start date
S

Scott Morton

I have a formula that works out a value - that value is also the name of
a worksheet, Can I do a lookup to a worksheet from that formula:
e.g.

Script number = 1.1 (Formula value = 1.1)

Now I want insert from cell "A4" in worksheet "1.1" (Fornula result)

Is this possible?

Hope I have explained it clearly enough.

Thanks in advance
 
Assuming your formula is in A1 (evaluates to: 1.1)
then we could put in B1: =INDIRECT("'"&A1&"'!A4")
to retrieve the contents in 1.1's cell A4
(B1 returns the same as the link formula: ='1.1'!A4)
 
You must log in or register to reply here.

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

Scrabble Value calculation for Welsh words 0
Excel VBA 1
Worksheet Names using Macros 5
VLOOKUP and OFFSET 3
How do I have a cell value define a dynamic named range? 15
Excel Moving data to sheet2 from sheet1 0
Calculate _worksheet_ for soruce data? 1
Copying a formula containing the INDIRECT function 7

Back
Top