In this Microsoft Excel video tutorial I explain how to return a blank instead of a zero when performing a lookup. I also explain how to return a blank instead of the date 1/0/1900. This method works for VLOOKUP, XLOOKUP and INDEX MATCH.
Click here to download the featured file.
Video Table of Contents
00:00 – Introduction
Custom Number Format Solutions to Replace Zero with Blank
00:27 – Custom number format to replace 1/0/1900 date with blank
01:57 – Custom number format to replace zero with blank
02:44 – Custom number format to return blank instead of zero for text lookup
Formula Solutions to Replace Zero with Blank
03:42 – IF INDEX MATCH =”” (empty text string)
04:38 – IF ISBLANK INDEX MATCH
05:16 – IF LEN INDEX MATCH
06:14 – IF VLOOKUP
06:38 – IF XLOOKUP