Skip to content
Home » Return Blank Instead of Zero With VLOOKUP, XLOOKUP or INDEX MATCH | Return Blank Instead of 1/0/1900

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

    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