Syntax Help

  • Thread starter Thread starter DM
  • Start date Start date
D

DM

Hello All,

Can anyone help me modify this formula to include if the
value is the word NULL, then leave the cell blank.

Inotherwords, return the values requested but if the value
is the word NULL, then leave the cell blank.

Thanx much

=IF(ISERROR(VLOOKUP(H4,Tivoli,7,FALSE)),"",VLOOKUP
(H4,Tivoli,7,FALSE))
 
Hi

Try this:

=IF(ISERROR(VLOOKUP(H4,Tivoli,7,FALSE)),"",IF(VLOOKUP(H4,Tivoli,7,FALSE)="NU
LL","",VLOOKUP(H4,Tivoli,7,FALSE)))
 
Thanx Andy,

Tried it and it did not work....the word NUll still came
back...for some reason it did not ignore the word Null..

DM
 
Hi

Is the word NULL typed in by someone, or does it appear as a result of
custom formatting? If the cell has formatting that tells it to display NULL
rather than blank, the formula will not work.
 
Null is a word that is contained in the cell...see the
values returned are from a query....NULL is the result of
the info from the query being blank so when the info comes
back to excel, it places the word NULL in the cell meaning
no information was in the column requested from the
query....So my goal is to say okay if the word NULL is
returned...leave it blank....

DM
 
So, if you click on the cell, in the formula bar it says NULL. If that is
the case, my formula should work. If NULL is in A1, in an adjacent cell,
type
=A1="NULL"
and see what you get. It should be TRUE
 
Okay so I went to my Query page, clicked on the return
cell that contained the word NULL.. G3, verified that NULL
appeared in the formula bar...clicked the adjacent cell,
typed in =G3="NULL"...it came back true...HMM...don't know
why when I use this formula and I agree, it should work....

???
 
Andy,

Now it is working...I set the format on the query page
from General to text, then re-entered the formula all on
one line in the formula bar..now it is
working...hmm...should have worked regardless but I will
take it...

Thanx and sorry for the confusion....
DM
 
Back
Top