"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