If Statement Help!!

[Dmorri]

Hi,

Can someone please check this formula and let me know if
it is correct? What I am trying to do is say IF the cell
says NULL then leave it blank....It is accepting the
formula but the cell is not blank if contains the word
NULL..very confusing....

Thank you

=IF($T2>246,$T2,IF(ISERROR(VLOOKUP
($H2,MatchTo,2,FALSE)),"",IF(VLOOKUP($H2,MatchTo,2,FALSE)
="NULL","",VLOOKUP($H2,MatchTo,2,FALSE))))

 

[Frank Kabel]

Hi
formula looks o.k.
maybe some spaces / hidden characters in your lookup range?

 

[Dmorri]

Hmm...yeah I checked for that and found none....can't
figure this one out...
Thanx for looking at it ...

 

[Dmorri]

Maybe this will help....

Okay here is the original formula that I am trying to
modify to say If the cell contains NULL, then leave it
blank...

=IF($T18>246,$T18,IF(ISERROR(VLOOKUP
($H18,MatchTo,2,FALSE)),"",VLOOKUP($H18,MatchTo,2,FALSE)))

 

[Dmorri]

I think I know why it does not work...tell me if I am
correct....This formula brings back results based on what
is in another cell...so IF cell $T2>246 then bring me back
the number in T2. Okay so in the orginal it says if blank
then do nothing..>So I think my If NULL modification only
says if the cell I am in says NULL then leave it
blank ...it does not deal with the information in T2 which
the formula is based on....so for it to work, I think the
NULL needs to be somewhere in the beginning IF
statement ...is this correct??? IF so, where do I place
this??

 

[RagDyeR]

Is there a possibility that the "Null" that's in the range "MatchTo", might
have leading or trailing spaces, which would therefore *not* match the
"Null" in your formula?
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



I think I know why it does not work...tell me if I am
correct....This formula brings back results based on what
is in another cell...so IF cell $T2>246 then bring me back
the number in T2. Okay so in the orginal it says if blank
then do nothing..>So I think my If NULL modification only
says if the cell I am in says NULL then leave it
blank ...it does not deal with the information in T2 which
the formula is based on....so for it to work, I think the
NULL needs to be somewhere in the beginning IF
statement ...is this correct??? IF so, where do I place
this??