I want to get text data from a different worksheet depending on the value I
put in the formula. Can I name worksheets using numbers (1,2,3,...) and use
changing values in formulas to refer to the different worksheet?

e.g.: On my summary worksheet, different cells should get data from
1st cell = a value in a cell in worksheet 1
2nd cell = a value in a cell in worksheet 2
etc.
--
sdm

Hi,

Yes, but you don't need to name them with number. In any case use INDIRECT.

And if you use a value in the formula (the sheet name is still text) so you
will need to convert the sheet name to a number in the formula (could use
VALUE) or you need to convert the number to text using TEXT.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"sdm" wrote:

I want to get text data from a different worksheet depending on the value I
put in the formula. Can I name worksheets using numbers (1,2,3,...) and use
changing values in formulas to refer to the different worksheet?

e.g.: On my summary worksheet, different cells should get data from
1st cell = a value in a cell in worksheet 1
2nd cell = a value in a cell in worksheet 2
etc.
--
sdm