naming formula

R

R.VENKATARAMAN

formula can be named. i click <ctrl+function key F3> give a name
"yearbefore" and in the reference type<=year(today())-1>
and in any cell i hit function F3 and select <yearbefore> enter twice I get
2002. But if I give the name as "lastyear" it does not work . it gives
<#name?>. what mistake am I doing?

if the formula contains a cell address it works but it seems to take the
absolute addresses.
e.g.name <lookup> and reference is <vlookup(a5,data,2,false)> it takes $A$5.
any comments

Excel 2000

thanks and regards
 
J

Jim Rech

AutoCorrect is changing "=lastyear" to "=last year". Edit out the space.
If you want to use that name a lot you might remove lastyear from your
AutoCorrect list (Tools, Autocorrect options).
 
Z

Zakir Ulla

Hi Venkat,

This is the problem of the AutoCorrect options, where the word
"lastyear" is replaced by "last Year", hence excel gives an error....
as the formula becomes <=last year>...

To avoid this change/delete the AutoCorrect option for the work "last
year" to be replaced....

Else

Insert an underscore in the name <=last_year>

regards,

Zakir Ulla
[email protected]
 
Top