Get rid of #N/A

[foilprint0]

Hi

I have a row of cells with the following type of formula
=HLOOKUP(F29,HANDI!$C$9:$AF$26,18,TRUE)
when the cells that this refers to has values in it is fine but whe
they are empty I get #N/A
Is there a way of not having the #N/A when there are no values

 

[Frank Kabel]

Hi
one way:
=IF(ISNA(HLOOKUP(...)),"",HLOOKUP(...))