Help with INDIREC

M

MESTRELLA29

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...
 
Top