David,

I will be changing the "Month of March 06" cell to the following month each
month. How can I get the value that had been pulled in by this formula to
remain in the cell after this cell is changed. I have set up the same
formulas for each month of the year in subsequent cells but I need the
previous information to remain after the month name has changed in this cell.
Any ideas?
--
Rebecca


"David Biddulph" wrote:

> "Rebecca" <[email protected]> wrote in message
> news:[email protected]...
> > =IF('Natl Rank'!C1="Month of March 06",""=VALUE('1'!C9)) ???? Not
> > right.....
> >
> > If Excel spreadsheet tab, Natl Rank, cell C1 = Month of March 06, I want
> > to
> > reveal the "value" of spreadsheet tab 1, cell C9, in spreadsheet Natl
> > Info,
> > cell B61.
>
> =IF('Natl Rank'!C1="Month of March 06",'1'!C9,"")
> should do.
> VALUE doesn't in general do anything for you (look at the help for the
> function).
> Your pair of double quotes & equals before the VALUE will probably have
> confused the formula.
> If you want the cell blank for anything other than "Month of March 06" in
> C1, you need the "" for the false condition.
> --
> David Biddulph
>
>
>