Online Excel Formula Returns Value Instead of Blank

%3CLINGO-SUB%20id%3D%22lingo-sub-2002316%22%20slang%3D%22en-US%22%3EOnline%20Excel%20Formula%20Returns%20Value%20Instead%20of%20Blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2002316%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20regular%20desktop%20Excel%20the%20below%20formula%20would%20make%20the%20cell%20blank%20(no%20value).%20However%2C%20in%20the%20web%20version%20of%20excel%2C%20it%20is%20returning%20a%20value%20of%200.%20I%20need%20it%20to%20return%20a%20blank%20as%20the%200%20value%20will%20cause%20errors%20with%20copy%20paste%20of%20data%20into%20other%20spreadsheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20know%20how%20to%20get%20the%20result%20of%20%22%22%20to%20be%20blank%20instead%20of%200%20in%20online%20excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DIFERROR(VLOOKUP(A276%2C'ME%20Checklist'!A275%3A%24B%24500%2C2%2CFALSE)%2C%22%22)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2002316%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2002379%22%20slang%3D%22en-US%22%3ERe%3A%20Online%20Excel%20Formula%20Returns%20Value%20Instead%20of%20Blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2002379%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F906677%22%20target%3D%22_blank%22%3E%40ltyner%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20to%20leave%20space%20%22%20%22%2C%3C%2FP%3E%3CP%3Ein%20your%20formula%20there%20is%20no%20space%20between%20the%20%22%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2002381%22%20slang%3D%22en-US%22%3ERe%3A%20Online%20Excel%20Formula%20Returns%20Value%20Instead%20of%20Blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2002381%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F87534%22%20target%3D%22_blank%22%3E%40Jihad%20Al-Jarady%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20that%20does%20not%20work%20either%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

In regular desktop Excel the below formula would make the cell blank (no value). However, in the web version of excel, it is returning a value of 0. I need it to return a blank as the 0 value will cause errors with copy paste of data into other spreadsheets.

 

Anyone know how to get the result of "" to be blank instead of 0 in online excel?

 

=IFERROR(VLOOKUP(A276,'ME Checklist'!A275:$B$500,2,FALSE),"")

4 Replies

Hi @ltyner 

 

Try to leave space " ",

in your formula there is no space between the ""

Thank you @Jihad Al-Jarady 

Unfortunately, that does not work either

@ltyner I just tried to recreate that and can't.  can you share the sheet?  are you sure you are getting an error?  try replacing "" with "ERROR" or "9999999" and see if you are even getting an error.

BTW, consider using XLOOKUP(A276,'ME Checklist'!A275:$A$500,'ME Checklist'!B275:$B$500,"") which has a "not found" option built in

@ltyner 

In Excel no one formula returns blank as a value, that's awaited functionality. In your case formula returns empty string "", but that's not a blank cell which considered as zero in calculations. For example, if your formula in A1 and it returns empty string, =A1+1 shall give #VALUE! error. If A1 is actually blank result will be 1.

Two variant - or Excel Online in your case has some advanced functionality (or bug), or your copy/paste incorrectly. Without the sample file it's hard to say more.

Sample could be as simple as: in A1 is 1, in B1 is 0, in C1 is =IFERROR(A1/B1,"")