Excel Magic Trick 1260


VLOOKUP Returns Zero when Lookup Table Contains Empty Cell? 3 Fixes.
Learn how to prevent VLOOKUP from returning a zero when it sees an empty cell in the lookup table:
(00:12) Problem setup.
(00:49) Create Sequential Numbers for the col_index_num in VLOOKUP using COLUMNS function and expandable range when you are copying formula across the columns.
(03:27) Solution #1: Custom Number Format Solution. Learn about the four sections for Custom Number Formatting
(05:55) Solution #2: Formula Solution with VLOOKUP and IF functions
(07:33) Solution #3: Create Zero-Length Text Strings in empty cells in lookup table.