Need formula to lookup a named range

Giganews Newsgroups
Subject: Need formula to lookup a named range
Posted by:  DMDave (captivator…@hotmail.com)
Date: Sat, 06 May 2006

Hi, I'm trying to figure out a formula to lookup a named range based
on the month (e.g. Jan) entered in a cell on the sheet.

For instance:

on sheet 'Sales Page, in cell C1 I will enter the month (Jan).

I have a named range on sheet 'NS2005 called "Jan2005.355".

I want a cell in 'Sales Page to look at C1 and find the named range
that has the same first three letters of the month and return the sum
of the range.

e.g.
in cell C1 of 'Sales Page is Jan and it finds and returns the sum of
named range Jan2005.355

or if C1 is Feb it finds and returns the sum of named range
Feb2005.355.

I tried using=CONCATENATE(T($C$1),2005.355) but apparently the result,
while returning the correct name, Jan2005.355, does not work as a
named range or excel doesnt recognize it.

Any help will be greatly appreciated.

Dave

Replies