Tags: asking, avoid, column, create, display, excel, experts, false, formula, m6o8, microsoft, msdn, occasional, software, value, vlookup

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

On Microsoft » Microsoft Excel

1,684 words with 2 Comments; publish: Fri, 23 May 2008 19:58:00 GMT; (30662.50, « »)

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.

--

Regards,

Marvin Hlavac

Toronto, Canada

All Comments

Leave a comment...

  • 2 Comments
    • 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

      "Marvin Hlavac" <hlavac.excel.questionfor.info.rogersSPAM.com> wrote in message

      news:%23FvUBbotDHA.2432.excel.questionfor.info.TK2MSFTNGP10.phx.gbl...

      > 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.

      > --

      > Regards,

      > Marvin Hlavac

      > Toronto, Canada

      >

      #1; Fri, 23 May 2008 20:00:00 GMT
    • 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!!!

      --

      Regards,

      Marvin Hlavac

      Toronto, Canada

      > 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

      #2; Fri, 23 May 2008 20:01:00 GMT