+ Reply to Thread
Results 1 to 7 of 7

vlook up and if formula

  1. #1
    Stuart
    Guest

    vlook up and if formula

    hi

    im playing with a spreadsheet at the moment trying to use vlookup which i
    have working

    however, instead of when the vlookup value providing a value of n/a when
    false, is there a way that i can use an if statement to return a value of "0"
    (zero)

    thanks

    stuart

  2. #2
    Leo Heuser
    Guest

    Re: vlook up and if formula

    Hi Stuart

    One way:

    =IF(ISERROR(Your formula),0,Your formula)

    --
    Best Regards
    Leo Heuser

    Followup to newsgroup only please.

    "Stuart" <Stuart@discussions.microsoft.com> skrev i en meddelelse
    news:8F10ABE4-0C75-4691-B6D1-0B6BCAC59DBF@microsoft.com...
    > hi
    >
    > im playing with a spreadsheet at the moment trying to use vlookup which i
    > have working
    >
    > however, instead of when the vlookup value providing a value of n/a when
    > false, is there a way that i can use an if statement to return a value of
    > "0"
    > (zero)
    >
    > thanks
    >
    > stuart




  3. #3
    arno
    Guest

    Re: vlook up and if formula

    Hi Stuart,

    > however, instead of when the vlookup value providing a value of n/a
    > when false, is there a way that i can use an if statement to return a
    > value of "0" (zero)


    you need your formula twice, eg.

    =if(iserror(vlookup(a1,data,2,false)),0,vlookup(a1,data,2,false))

    where 0 in the middle of the formula is what you want. sometimes I use
    "not found", "---" or just "", depending on what is usefull in the
    situation, 0 is fine, too.

    arno



  4. #4
    Duke Carey
    Guest

    RE: vlook up and if formula

    =if(isna(vlookup formula),0,vlookup formula)

    "Stuart" wrote:

    > hi
    >
    > im playing with a spreadsheet at the moment trying to use vlookup which i
    > have working
    >
    > however, instead of when the vlookup value providing a value of n/a when
    > false, is there a way that i can use an if statement to return a value of "0"
    > (zero)
    >
    > thanks
    >
    > stuart


  5. #5
    stuart
    Guest

    RE: vlook up and if formula

    thanks for everyone's help

    stuart




    "Stuart" wrote:

    > hi
    >
    > im playing with a spreadsheet at the moment trying to use vlookup which i
    > have working
    >
    > however, instead of when the vlookup value providing a value of n/a when
    > false, is there a way that i can use an if statement to return a value of "0"
    > (zero)
    >
    > thanks
    >
    > stuart


  6. #6
    Leo Heuser
    Guest

    Re: vlook up and if formula

    You're welcome, Stuart :-)

    LeoH



    "stuart" <stuart@discussions.microsoft.com> skrev i en meddelelse
    news:F43760FF-12C9-4400-97AF-F02F786337D7@microsoft.com...
    > thanks for everyone's help
    >
    > stuart




  7. #7
    Leo Heuser
    Guest

    Re: vlook up and if formula

    You're welcome, Stuart :-)

    LeoH



    "stuart" <stuart@discussions.microsoft.com> skrev i en meddelelse
    news:F43760FF-12C9-4400-97AF-F02F786337D7@microsoft.com...
    > thanks for everyone's help
    >
    > stuart




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1