VLOOKUP returns 0 (zero) when lookup cell is blank

  • Thread starter Thread starter Maki
  • Start date Start date
M

Maki

When the cell that VLOOKUP looked-up is blank, it displays 0 (zero).
How can I prevent this and make it to not show anything? i.e. blank?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting 0 values to show blank cells 4
Using COUNTA and excluding formulas that gives zero or blank cells 3
VLOOKUP returns 0 (zero) when lookup cell is blank 5
Vlookup blanks = zeros 6
how do i remove the 0 in the cells 6
=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"",VLOOKUP(F2,Mast 3
Blank 3
show all/pivot - 2 questions 1

Back
Top