Jul 03 2022 08:05 AM
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?
Jul 03 2022 08:13 AM
Jul 03 2022 08:24 AM
Jul 03 2022 08:47 AM
Jul 03 2022 09:00 AM
Jul 03 2022 09:21 AM
SolutionYou 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.
Jul 03 2022 09:32 AM
Jul 03 2022 10:28 AM
Jul 03 2022 12:34 PM
@Jane_at_Stamma , you are welcome
Jul 03 2022 09:21 AM
SolutionYou 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.