Using a Name in a formula

[Brian Ritchie]

Excel 2003

I am trying to use a name in a formula in accounts, which change every month
and the name which I want to look up depends on the month I am producing.

The formula is
=SUMIF('Lookup Data'!$E$2:$E$2422,$C7,mar05lum)

I would like to derive the mar05lum from the lookup of another table as
follows.

Jan-06 Jan06act jan06tb jan06lum jan06luy jan05lum jan05luy
Feb-06 Feb06act feb06tb feb06lum feb06luy feb05lum feb05luy
Mar-06 Mar06act mar06tb mar06lum mar06luy mar05lum mar05luy
Apr-06 Apr06act apr06tb apr06lum apr06luy apr05lum apr05luy

I have set up one cell to return the mar05lum on the basis of the date, but
I am not sure how I can then use that in the part of the formula, so that it
looks up the range mar05lum

I am not sure how to do this - do I need to use value(C5) or text (C5), or
something else.

Hopefully you will understand this.

Brian

 

[daddylonglegs]

Try

INDIRECT(C5)

 

[Ardus Petus]

Assuming all your names are defined and each refers to a range and C5
contains a the formula whose result is "mar05lum", you can use;
=SUMIF('Lookup Data'!$E$2:$E$2422,$C7,INDIRECT(C5))

HTH

 

[Bob Phillips]

=SUMIF('Lookup Data'!$E$2:$E$2422,$C7,INDIRECT(cell_with_data))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Brian Ritchie]

Perfect Thanks

Brian

=SUMIF('Lookup Data'!$E$2:$E$2422,$C7,INDIRECT(cell_with_data))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)