Vlookup

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I am using the vlookup function to look up data over
several columns. If there is nothing in one column, I
would like for it to return a blank cell instead of the 0
it returns now. Is there something else I can put in the
formula to do this. Any help will be appreciated. Thanks
in advance.
 
Todd,

Best thing to do would be to post the formula that you're using.
You could test to see if the vlookup returns a zero and change it
to a blank or you may just want to set your page up to not display
zeros.
Tools/Options/View & uncheck "Zero Values"

John
 
You must log in or register to reply here.

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

Excel IF statement with vlookup 2
VLOOKUP returns 0 (zero) when lookup cell is blank 5
Vlookup Formula Help 3
VLOOKUP Problem 1
=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"",VLOOKUP(F2,Mast 3
Vlookup issue 6
VLOOKUP returning #N/A result 2
vlookup 5

Back
Top