Parameterisation of table names

  • Thread starter Thread starter Tom O''Riordan
  • Start date Start date
T

Tom O''Riordan

Hello

I need to name various tables in excel, by tables I mean a group of cells
(e.g A1:D56). 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
 
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(A1:D10)
and if H1 contains the text blok, then:

=SUM(INDIRECT(H1)) will do the same.
 
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
 
Back
Top