Vlookup

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.
 
J

John Wilson

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
 
Top