intersection of named ranges

[david.barbetta]

My worksheet has several named rows (e.g. "Wins", "Losses", etc). If I
were to name the columns as well (e.g. "Year1999", "Year2005", etc),
could I use the named ranges in my formulas to get, say, wins for year
2002? Something like ... =INTERSECTION(WINS,Year1999). Is there a
formula (or combination of fuormulas) in Excel 2000 that will do this?

If not, can I at least use the named rows in my formulas ... e.g.
something like =Cells(Wins, "C") ?

Thanks.

 

[Art Farrell]

Hi,

Use =Wins YR1999
where Wins is a named row or range and YR1999 is a named column or range.
Just put a space between the entries.

CHORDially,
Art Farrell