How about
=if(a6="", "",formula
or
a6=0


--
Don Guillett
SalesAid Software

"KenRamoska" wrote in message
...
Hi, I have a working VLOOKUP below. Of course the desitination cell says
#N/A
until I put something in A6. I tried ISERROR but it says too many
arguments.
Did I do this wrong? Can anyone help? Thanks.



=IF(VLOOKUP(A6,CSM,8)="X","X",IF(VLOOKUP(A6,NPM,8) ="X","X",IF(VLOOKUP(A6,PM,
8)="X","X"," ")))