Excel – How to prevent vlookup returning 0 for values that are blank in the lookup data?

microsoft-excel-2010vlookup

My vlookup call in an Excel 2010 spreadsheet is returning a value of 0 for values that are blank in the lookup data.

How can I force vlookup to return a blank when the data is blank, and 0 when the data is 0?

Best Answer

This method works, though it would certainly be nice if there was a better method:

=if(len(vlookup(a2,f$2:g$20,2))=0,"",vlookup(a2,f$2:g$20,2))
Related Question