How to make my formula display only "value" not occasional #N/A

  • Thread starter Thread starter Marvin Hlavac
  • Start date Start date
M

Marvin Hlavac

I would like to avoid having to create a helper column so here I am again
asking the experts:

My formula is this:

=VLOOKUP(C7,M6:O8,3,FALSE)

If it doesn't find an exact mach it will display #N/A. I would like to
modify this formula to display nothing "" instead of #N/A

Thanks in advance.
 
Marvin,

You can write the formula like

=IF(ISERROR(VLOOKUP(C7,M6:O8,3,FALSE)),"",VLOOKUP(C7,M6:O8,3,FALS
E))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Hi Chip,

Perfect, perfect, perfect!!! Chip Thanks a lot!!! It does exactly what I
needed and it took only 3 minutes for your reply to appear!!!
 
Back
Top