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
 
Back
Top