To all: Pete UK, MuppetMan, and Stefi. Why HLOOKUP? should be VLOOKUP instead.

=IF(ISNA(VLOOKUP(A1,A2:A6,1,0)),"",VLOOKUP(A1,A2:A 6,1,0))

I like this one better and more elegant

=IF(COUNTIF(A2:A6,A1),A1,"")


"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