Prev: Pick List + Alphabetical Skip To or Auto Complete
Next: Multiple AND OR functions
From: Mark D on 30 Apr 2010 08:01
Hi Again everyone.

Ok another problem I am now having.

I have the following formula in column H

=IF(ISNA(VLOOKUP(TRIM(A135),'Current running April
2010'!$1:$65536,1,FALSE)),"",VLOOKUP(TRIM(A135),'Current running April
2010'!$1:$65536,1,FALSE))

In Column I simply want to say

=IF(ISBLANK(h9),"","yes")

But it's returning yes even if the cell is blank.

Any ideas?

Thanks
From: Jacob Skaria on 30 Apr 2010 08:07
ISBLANK() validates only truly blank cells and not the ones having formulas....

=IF(H9="","","yes")

--
Jacob (MVP - Excel)


"Mark D" wrote:

> Hi Again everyone.
>
> Ok another problem I am now having.
>
> I have the following formula in column H
>
> =IF(ISNA(VLOOKUP(TRIM(A135),'Current running April
> 2010'!$1:$65536,1,FALSE)),"",VLOOKUP(TRIM(A135),'Current running April
> 2010'!$1:$65536,1,FALSE))
>
> In Column I simply want to say
>
> =IF(ISBLANK(h9),"","yes")
>
> But it's returning yes even if the cell is blank.
>
> Any ideas?
>
> Thanks
From: Ms-Exl-Learner on 30 Apr 2010 08:18
Because the H9 cell is not a blank cell and it will be having any formula on
it.

Try this…

=IF(LEN(H9)=0,"","Yes")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Mark D" wrote:

> Hi Again everyone.
>
> Ok another problem I am now having.
>
> I have the following formula in column H
>
> =IF(ISNA(VLOOKUP(TRIM(A135),'Current running April
> 2010'!$1:$65536,1,FALSE)),"",VLOOKUP(TRIM(A135),'Current running April
> 2010'!$1:$65536,1,FALSE))
>
> In Column I simply want to say
>
> =IF(ISBLANK(h9),"","yes")
>
> But it's returning yes even if the cell is blank.
>
> Any ideas?
>
> Thanks
 | 
Pages: 1
Prev: Pick List + Alphabetical Skip To or Auto Complete
Next: Multiple AND OR functions