Hide #N/A

  • Thread starter Thread starter Mark Flynn
  • Start date Start date
M

Mark Flynn

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
 
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
 
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
Click to expand...

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
 
Back
Top