1. 

   Rykard Private E-2

   Hi,
   I have a column that is defined as 'general' the contents are to be found via vlookup in another workbook (column defined as text). My problem is that if the returned data is blank then '0' is showing not 'blank' . Is there a way I can format the columns to not show the 0?
   
   thanks
   Rich

    

   Rykard, Feb 13, 2013

   #1
2. 

   Rykard Private E-2

   sorted it. I had to put an IF statement round the vlookup saying if the vlookup returned 0 then spaces else vlookup value...

    

   Rykard, Feb 13, 2013

   #2

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in

---

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds

---