If function that returns value in a cell.
 

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

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

BTW,

You'll notice that when the Source WB is closed, the path in the formula
might expand "greatly", depending on just exactly where (File, Folder,
Directory, Drive) the Source WB is located.

Also, every time you open the Target WB, you'll get a request to "Update
Links",
where you have the option to check the Source WB for new data, or to
continue with the data at hand, from the "last" update.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
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

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

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