How to how #n/a as an empty cell in an excel table (not chart)

Hi - I'm trying to create a list in excel - from various sources - and where it comes up as #N/A or 0 I'd like just a blank. How do I do this?

Diamond Contributor

Jul 03, 2022

You shall use or comma or semicolon as delimiter, depends on you regional settings, Mix doesn't work. If comma, it could be like

=IFERROR(
  IF( VLOOKUP( G7, FinalWorkshops, 4) = 0,
        "",
       VLOOKUP(G7,FinalWorkshops,4) ),
 "")

If you open attached file and check G16 it'll be the formula in your locale.

Copper Contributor

Jul 03, 2022

Oh, thank you so much!!! That worked.

Forum Discussion