Help with INDIREC

G

Guest

I have this simple formula:
=comida!B6

what i need is to have the content of a Cell that could change the sheet name,

Example Cell a1 in sheet1 change from Comida to Comida2, this updating the
sheet name link.

Can tis be dolne?
 
D

Dave Peterson

How about:
=INDIRECT("'"&A1&"'!b6")



I have this simple formula:
=comida!B6

what i need is to have the content of a Cell that could change the sheet name,

Example Cell a1 in sheet1 change from Comida to Comida2, this updating the
sheet name link.

Can tis be dolne?
Click to expand...
 

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

Code Adjustment 3
EXCEL - IF(IFERROR(VLOOKUP question 0
Code to format cells on several worksheets 2
Excel formula help please? 7
Multisheet range in SUMPRODUCT? 5
Excel Import Comments 3
SUMIF function and cell /sheet reference 3
Hyperlink via indirect cell reference 8

Top