Forum Discussion
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?
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.
Thank you. The current contents has for example, "=VLOOKUP(F2,FinalWorkshops,4)" ; how do I wrap that? Initial attempts failing.
- sorry, total novice here, so I typed in this
=IFERROR( IF (VLOOKUP(G7,FinalWorkshops,4)=0 ""; VLOOKUP(G7,FinalWorkshops,4) ; "")
which didn't work- Because your list separator is not ";". Your list seperator is ","
You can see it in your vlookup formula. 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.
- Oh, thank you so much!!! That worked.
