Read data from another worksheet

**discoverdean** · 10-28-2008, 08:38 AM

Hi,
I am trying to read data from one worksheet to another, this is straight forward but I am stuck as I would like excel to look at the cell in the worksheet i'm reading the data from & if the cell is blank I would like to return a blank to the cell on the 2nd worksheet.

I have this at the mo, which obviously doesn't work:
=DATA!L$14,IF(DATA!L$14=" "," ")

Can anybody help ?

**rwgrietveld** · 10-28-2008, 08:42 AM

=IF(ISBLANK(DATA!L$14),"Blank","Not Blank")

**EdMac** · 10-28-2008, 08:54 AM

Or try

=IF(DATA!L$14="","",Data!L$14)

**discoverdean** · 10-28-2008, 08:56 AM

Sorry, I'm not sure I was clear.....
When I say blank, I mean " " & not "blank".
So what I would like to happen is to look at a cell, if it has a value, return it. If there is no value I would like it to return " " (nothing). Currently I have it returning a 0 (zero) which is messing up my conditional formatting.

**discoverdean** · 10-28-2008, 09:07 AM

Super !!

Ed, seems to be exactly what I am looking for.

Much appreciated !

**EdMac** · 10-28-2008, 09:11 AM

No Problem, thanks for the feedback.

Please remember to mark the thread as solved - see the instructions if you are not sure how to do it.

**discoverdean** · 10-28-2008, 09:40 AM

Hi Ed,
How do you make as 'solved'. Had a search around but cannot find anything. I thought it would have been straight froward but that doesn't seem to be the case.

Could you give me a clue where to find it ?