Do it like this:

=IF(ISNA(hlookup(A1,A2:A6,1,false)),"",hlookup(A1, A2:A6,1,false))

ISNA checks for #N/A and returns a blank if necessary.

Hope this helps.

Pete

On Sep 29, 12:58*pm, RodJ wrote:
the result of my hlookup is #N/A as my formula reads:
hlookup(A1,A2:A6,1,false).

Question: How do I make this #N/A invisible? I would rather see a blank cell
as it clutters my spreadsheet.

Thanks
--
RodJ