Steve.

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

--
Rebecca


"SteveG" wrote:


rebecca,

In Natl Info B61

=IF('Natl Rank'!C1="Month of March 06",'1'!C9,"")

Assuming that your sheet tab 1 is named "1". This returns a blank if
the condition is not true. It looks like you had the value if true and
value if false reversed.

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=530567