If,iserror or blank

[lal12]

Trying to write a formula to say if a cell is an error from a vlookup then do a value or if its blank do nothing. Current formula is below. I want it to return nothing if C547 is blank. Right now the cell is returning a 0.

=IF(ISERROR(VLOOKUP(C547,N:O,1,FALSE)),H547,H547*0.1)

 

[tweedle]

try...

=IF(ISBLANK(C547),"",IF(ISERROR(VLOOKUP(C547,N:O,1,FALSE)),H547,H547*0.1))

 

[lal12]

Thanks perfect.

 

[Scott Huish]

No need for the VLOOKUP or ISERROR:

=IF(OR(C547="",ISNA(MATCH(C547,N:N,0))),0.1,1)*H547