Return Blank Instead of Zero With VLOOKUP, XLOOKUP or INDEX MATCH | Return Blank Instead of 1/0/1900 

I wish i found this video a month ago. There's so much to learn with excel, I'm just working it out as i go... I've been using it in a limited way for years. I've been setting the sheets to not display zeros globally in program options where it was a problem for me but sometimes seeing a zero is a good thing.

Thank you so much! I was dealing with a super weird issue where my master sheet was performing multiple vlookups on a 2nd worksheet. For some reason, one date column was returning zero, while the other was just returning a blank cell. I wanted a blank cell to return a blank value, but I was getting different results. It made no sense, but the custom format with ;;; was a super easy workaround.

OMG. THANK YOU times a million!!! This instructional video will save us so much time in the future!

beautifullll

Excellent tutorial Chester. Another great video. Thank you for these techniques!

Thank you so much! You have saved me MONTHS of work!!!!!!

how even though it's blank, the countif / sumif formula doesn't calculate it?

​ For Colombia use the following format DD/MM/YYYY;; Thank you...

I just sub'd.thank you!.. is this the same when linking 2 workbooks which already had a link formula on the cells?

why no video today :)