How to get linked file from worksheet to = "blank"

S

seno

Hi people of the superior power of excel,


I have 2 worksheets Apple and Orange.

Field A1 in Apple worksheet contains no information "blank" nothings
entered.

I want to copy the information in A1 Apple to A2 Orange.

I assumed Field A2 Orange = Apple!A1.
but the field shows the value 0. I changed the properties to text but
it still shows 0.

What is the correct formula to ensure field A2 Orange = "blank"?
 
H

Harimau

=IF(ISBLANK(Apple!A1), "", Apple!A1)

It'll return the value of Apple!A1 if a non-blank value exists, but return
blank is Apple!A1 is blank.
 
P

Pete_UK

If you have a formula which returns a blank on that first sheet, then
you will need to do it this way:

=IF(Apple!A1="","",Apple!A1)

Copy across and down as required.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count no. of occurance in 2 dynamic columns within a data period 7
Fix EXACT function so it always compares in the same row. 5
Consolidate Lists from Multiple Sheets on another Sheet 9
Extract info from one sheet to another 2
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10
How to choose maximum value 7
How to fill in range of blank rows wth data fr last row previos ra 1
how to re-group the cells from vertical to horizontal 1

Top