Get rid of #N/A


F

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top