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

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

Try this:

=IF(ISERROR(HLOOKUP(A1,A2:A6,1,FALSE)),"",HLOOKUP( A1,A2:A6,1,FALSE))

Regards,
Stefi

€žRodJ€� ezt Ã*rta:


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

Alternatively, to avoid using two HLOOKUP functions -

=IF(COUNTIF(A2:A6,A1)0,HLOOKUP(A1,A2:A6,1,FALSE), "")

Muppet Man.

On Sep 29, 1:10*pm, Pete_UK wrote:
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- Hide quoted text -

- Show quoted text -

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

Hi Ashish, I tried this and failed. I might have chosen the wrong option...
--
RodJ


"Ashish Mathur" wrote:

Hi,

You could also use conditional formatting to conceal error values

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"RodJ" wrote in message
...

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