Dueling Excel 131

Prevent VLOOKUP from Returning a Zero (4 Methods)

DESCRIPTION

See Mr Excel and excelisfun use two methods to Prevent VLOOKUP from Returning a Zero:
1. Alter the lookup table so there are not empty cells
2. Custom Number Formatting
3. IF and VLOOKUP method 1
4. IF and VLOOKUP method 2

WORKBOOKS




Be the first to comment

Leave a Reply