Include error checking

[Pat]

The following formula does not contain error checking:

=IF($N$25="","",IF((VLOOKUP($Q698,ControlPrePrice,2,0)=0,"",VLOOKUP($Q698,Co
ntrolPrePrice,2,0)))

does anyone know how it can be included?

Thanks
Pat

 

[Frank Kabel]

Hi Pat
one way (assuming you also want to test for a return of zero):
=IF($N$25="","",IF(OR(VLOOKUP($Q698,ControlPrePrice,2,0)=0,ISNA(VLOOKUP
($Q698,ControlPrePrice,2,0))),"",VLOOKUP($Q698,ControlPrePrice,2,0)))

Frank