Hide #N/A

  • Follow


I have VLOOKUP applied to the cells in a column.  When the "value" cell is
empty, the corresponding "results" cell in that row contains "#N/A"
Question:
How do I hide (or not display) "#N/A" ?
Thanks, Mark Flynn


0
Reply flynn (25) 8/13/2004 4:50:58 PM

=if(isna(vlookup),"",vlookup)

-- 
Regards,
Tom Ogilvy

"Mark Flynn" <flynn@NoSpam.uci.net> wrote in message
news:ubMhrXVgEHA.1656@TK2MSFTNGP09.phx.gbl...
> I have VLOOKUP applied to the cells in a column.  When the "value" cell is
> empty, the corresponding "results" cell in that row contains "#N/A"
> Question:
> How do I hide (or not display) "#N/A" ?
> Thanks, Mark Flynn
>
>


0
Reply twogilvy (1078) 8/13/2004 4:54:20 PM

Hi
use
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))

--
Regards
Frank Kabel
Frankfurt, Germany

"Mark Flynn" <flynn@NoSpam.uci.net> schrieb im Newsbeitrag
news:ubMhrXVgEHA.1656@TK2MSFTNGP09.phx.gbl...
> I have VLOOKUP applied to the cells in a column.  When the "value"
cell is
> empty, the corresponding "results" cell in that row contains "#N/A"
> Question:
> How do I hide (or not display) "#N/A" ?
> Thanks, Mark Flynn
>
>

0
Reply frank.kabel (11125) 8/13/2004 4:55:42 PM

Thank you Tom and Frank for your prompt reply.
I fiddled around, and plugged in my vlookup expression in Tom's example and
it worked:

=IF(ISNA(VLOOKUP(M4,Model_LookUp,2)),"",VLOOKUP(M4,Model_LookUp,2))

I appreciate your time, Mark Flynn

"Mark Flynn" <flynn@NoSpam.uci.net> wrote in message
news:ubMhrXVgEHA.1656@TK2MSFTNGP09.phx.gbl...
> I have VLOOKUP applied to the cells in a column.  When the "value" cell is
> empty, the corresponding "results" cell in that row contains "#N/A"
> Question:
> How do I hide (or not display) "#N/A" ?
> Thanks, Mark Flynn
>
>


0
Reply flynn (25) 8/13/2004 5:39:57 PM

On Fri, 13 Aug 2004 09:50:58 -0700, "Mark Flynn" <flynn@NoSpam.uci.net> wrote:

>I have VLOOKUP applied to the cells in a column.  When the "value" cell is
>empty, the corresponding "results" cell in that row contains "#N/A"
>Question:
>How do I hide (or not display) "#N/A" ?
>Thanks, Mark Flynn
>

In addition to what others have posted, you could use Conditional Formatting

Use the Formula Is: option.    =ISNA(cell_ref)  and format the font color to
the same color as the background color (default = white)


--ron
0
Reply ronrosenfeld (3124) 8/13/2004 5:58:08 PM

4 Replies
188 Views

(page loaded in 0.015 seconds)


Reply: