ExcelBanter - Help with INDIREC

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help with INDIREC (https://www.excelbanter.com/excel-discussion-misc-queries/44110-help-indirec.html)

MESTRELLA29

Help with INDIREC

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?

Dave Peterson

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

MESTRELLA29 wrote:

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?

--

Dave Peterson

All times are GMT +1. The time now is 09:40 PM.