Results 1 to 3 of 3

Thread: Formula: Tidy up Vlookup results

  1. #1

    Formula: Tidy up Vlookup results

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I need a quick fix to tidy up a vlookup function. below is the regular function:


    It works fine and such but is there an IF function I can put in so that if there is no value to return it returns 0 insteas of #N/A

    Thank you in advance.

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version


    or if you have Excel 2007/2010


  3. #3
    Quote Originally Posted by Bob Phillips View Post

    Thank you! This one worked great!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts