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" wrote in message
...
=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