If function that returns value in a cell.

R

rayteach

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(cell>0,,""} … 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?
 
R

Ragdyer

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,
Click to expand...
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")
 
R

Ragdyer

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.
 
Top