IF Statement Help Please!!

  • Thread starter Thread starter D.M.
  • Start date Start date
D

D.M.

Thank you to the person who gave me this tip. It works but
it does return the N/A value to the destination cell if it
is blank...I need it to leave the destination cell
blank...can anyone help me??

=IF(OR(ISERROR(VLOOKUP(M4,Test,10,FALSE)),VLOOKUP
(M4,Test,10,FALSE)=0),"",VLOOKUP(M4,Test,10,FALSE))

Thanx

D.M.
 
Wrap an IF and ISNA around it like;

=IF(ISNA(IF(OR(ISERROR(VLOOKUP(M4,Test,10,FALSE)),VLOOKUP(M4,Test,10,FALSE)=
0),"",VLOOKUP(M4,Test,10,FALSE))),"",IF(OR(ISERROR(VLOOKUP(M4,Test,10,FALSE)
),VLOOKUP(M4,Test,10,FALSE)=0),"",VLOOKUP(M4,Test,10,FALSE)))
 
Hi
try
=IF(ISNA(VLOOKUP(M4,Test,10,FALSE)),"",IF(VLOOKUP
(M4,Test,10,FALSE)=0,"",VLOOKUP(M4,Test,10,FALSE)))
 
Back
Top