Thanks for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"rayteach" wrote in message
...
Thank you so much, Ragdyer - your formula worked perfectly.
--
ray


"Ragdyer" wrote:

Let XL do the work for you.

Open both WBs.

Start your formula:
=IF(
Then navigate to the other WB, and click in the cell that you wish to
lookup.

XL will add the path to your formula.
Then, in the formula bar, add
0,
OR
<"",

Then click in the cell *again* to repeat the path for the "True"
condition.
End off by adding the "False" condition to the formula bar
,"")
OR
,"No Data")

Then hit <Enter.

Your formula might look something like this:

=IF(Sheet3!A1<"",Sheet3!A1,"No Data")
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-

"rayteach" wrote in message
...
I want to make an IF function that refers to a cell in another
worksheet
and
returns the value in that cell. All but the TRUE condition would be
=if(cell0,,""} €¦ In other words, if the referenced cell has data in
it, I
want whatever data is there to be the result of the formula. How do I
do
this?
--
ray