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 when they are empty I get #N/A
Is there a way of not having the #

 

[xlbo]

just do some error checking:
=if(isna(HLOOKUP(F29,HANDI!$C$9:$AF$26,18,TRUE)),"",HLOOKUP(F29,HANDI!$C$9:$AF$26,18,TRUE))


Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244