Help!!! MIKE H

  • Thread starter Thread starter Wu
  • Start date Start date
W

Wu

MIKE H, You are right, actually, I have set formulas into A2 and B2,

In A2 , ='sheet2'!F2 , THAT MEANS THE SOURCR OF A2 IF FROM F2 OF SHEET2
In B2 , ='sheet2'!G2
 
Hi,

No need to start another thread. The answer is the same, there must be text
in those cells on sheet 2. It could be spaces that you don't see as a result
of your formula but are still there.

Try this on a cell that 'looks' to be empty
=LEN(A2)

If it isn't 0 then there's something in the cell.

Mike
 
I'm not sure what your question is, but I'm thinking you need to go back and
look at the values in these cells.

'Sheet2'!F2
'Sheet2'!G2

--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.
 
Hi,

Two things:
1. Try moving to those empty cells and press Del. The cells may contain
spacebars.
2. Don't breakup a thread because it's a pain for us to track it down, even
worse when it has a new name which is so informative - "Help! Mike H"
 
Back
Top