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

Published: 15 February 2023
on channel: Chester Tugwell
26,373
286

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted...
Thank you! 👍👍
Download the featured file here: https://www.bluepecantraining.com/wp-...

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.

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
------------------------


Watch video Return Blank Instead of Zero With VLOOKUP, XLOOKUP or INDEX MATCH | Return Blank Instead of 1/0/1900 online without registration, duration hours minute second in high quality. This video was added by user Chester Tugwell 15 February 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 26,373 once and liked it 286 people.