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

[@christophereckert6978]

Thanks!

[@ChesterTugwell]

Many thanks

[@gonzinigonz]

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.

[@Raptorz24]

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.

[@lisajonescastronova5599]

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

[@EdMolina]

Thanks for this vid it helped me.

[@IvanCortinas_ES]

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

[@ChesterTugwell]

Glad you liked it!

[@MMaluenda1]

beautifullll

[@limitone9564]

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

[@vesaldiy8569]

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

[@linjr.delaespriellag.6776]

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

[@ceyhunkvrak7791]

why no video today :)

[@CustomWeddingGarter]

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