View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RodJ RodJ is offline
external usenet poster
 
Posts: 11
Default hlookup function dilemma


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