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