Thread
:
hlookup function dilemma
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
RodJ
external usenet poster
Posts: 11
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
Reply With Quote
RodJ
View Public Profile
Find all posts by RodJ