If you do a VLOOKUP to a reference cell which is empty, the VLOOKUP will return 0
To stop this you can apply a custom number format to the cell(s):
- Select the cell(s)
- from the Home tab select Format Cells
- Select Number and Custom format
- Enter custom number type :
0;;;@
Note: Whatever you put after the @ will be appended to the cell content
Also see
- Excel Tips…Using VLOOKUP
- Excel Tips…Using VLOOKUP to check if cell value found in second data set
- Excel Tips…Use custom cell format so numbers display with “+” and “-“
Leave a Reply