Results 1 to 2 of 2

Thread: vlookup

  1. #1
    Join Date
    Mar 2004
    Posts
    361

    Unanswered: vlookup

    is it possible for a vlookup function to return a value of 0 instead of "N/A" if the value doesn't exist??


    ex: =VLOOKUP(B676,Sheet1!B:C,2,FALSE)


    Thanks.

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    You can use the dreaded =IF(ISERROR(VLOOKUP),0,VLOOKUP))

    Or =IF(ISERROR(VLOOKUP),"",VLOOKUP))

    HTH,

    Smitty

Posting Permissions

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