Forum Discussion

Copper Contributor

Jul 03, 2022

Solved

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?

Copper Contributor

Jul 03, 2022

sorry, total novice here, so I typed in this
=IFERROR( IF (VLOOKUP(G7,FinalWorkshops,4)=0 ""; VLOOKUP(G7,FinalWorkshops,4) ; "")
which didn't work

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.