Forum Discussion
Online Excel Formula Returns Value Instead of Blank
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 ca...
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