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!

    Hello,

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

    =vlookup(B3,scrap!$B$4:$F$4,5,False)

    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
    Try

    =IF(ISNA(VLOOKUP(B3,scrap!$B$4:$F$4,5,False)),0,VLOOKUP(B3,scrap!$B$4:$F$4,5,False))

    or if you have Excel 2007/2010

    =IFERROR(VLOOKUP(B3,scrap!$B$4:$F$4,5,False),0)

  3. #3
    Quote Originally Posted by Bob Phillips View Post
    =IFERROR(VLOOKUP(B3,scrap!$B$4:$F$4,5,False),0)

    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
  •