If you think the problem is with the file name do this;
1) Type =IF(
2) Point to cell C24 on the other sheet
The Formula bar will read =IF(sheet_name!C24
3) Compete the formula by typing the rest
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Cyberbiker" wrote in message
...
It is actually just 40. I think that we tried the quotes on the "X", but
I'll try again. He has the file on his computer, but I don't have it here
on
mine. Thanks for your reply.

Dean

"John Bundy" wrote:

Is the name of the sheet actually 40? That is what you are showing with
the
'40'! if it is not, change it. Also put your 'X' in quotes "x".
--
-John
Please rate when your question is answered to help us and others know
what
is helpful.


"Cyberbiker" wrote:

Two of us who know just enough to be dangerous tried different
variations for
over 2 hours last night. We need to be able to pull data from sheet
40, cell
C24 and use it in an IF statement. We could pull the data from sheet
40 by
itself and insert it into a cell on our current sheet, then in a
different
cell, take that and use the IF, but we were unable to do it in one
step.

Here's basically what we tried, I am hoping this is possible and we
just
couldn't get the hang of the syntax:

=IF('40'!C24=X,1,0)

Any help will be greatly appreciated,

TIA