Parameterisation of table names

[Tom O''Riordan]

Hello

I need to name various tables in excel, by tables I mean a group of cells
(e.g A156). However I need to parameterise the name of the table to equal
another cell.

I know this may seem like a trivial matter but I really can't find how to do
it anywhere, please help.

Tom

 

[Gary''s Student]

Use a defined name:

Insert > Name > Define

So if A1 thru D10 have values and the Name blok has been assigned to this
range then:

=SUM(blok)

will display the same as =SUM(A110)
and if H1 contains the text blok, then:

=SUM(INDIRECT(H1)) will do the same.

 

[Roger Govier]

Hi Tom

It sounds as though you need the Indirect function.
If your named ranges are Group1, Group2 etc. and in cell D1 you had the
value Group1, then to refer to that range it would be
=INDIRECT(D1)

Alternatively, if you just had a number 1 in cell D1 then
=INDIRECT("Group"&D1)

Regards
Roger Govier