+ Reply to Thread
Results 1 to 4 of 4

Vlookup returns a zero?

  1. #1
    Richard
    Guest

    Vlookup returns a zero?

    Hi,

    I'm using vlookup to return a value, if there is one, from another
    worksheet. The problem I'm encountering is that vlookup will return a zero if
    there is no value to return. How do I get to return an empty cell if it
    cannot find a value to return?


    Thank You,

  2. #2
    Barb Reinhardt
    Guest

    RE: Vlookup returns a zero?

    =IF(isblank(a1),"",Vlookup(a1,....))


    "Richard" wrote:

    > Hi,
    >
    > I'm using vlookup to return a value, if there is one, from another
    > worksheet. The problem I'm encountering is that vlookup will return a zero if
    > there is no value to return. How do I get to return an empty cell if it
    > cannot find a value to return?
    >
    >
    > Thank You,


  3. #3
    njuneardave
    Guest

    RE: Vlookup returns a zero?

    Suppose if you are looking for a value....and ur search key is in B1 of
    Sheet1 and youre looking for it somehwere in column B of Sheet2 (between row
    2 and 1000)....

    =IF(ISNA(VLOOKUP(Sheet1!B1,Sheet2!$B$2:$B$1000,1,FALSE)),IF(ADataInputTable!B1 = "","", ADataInputTable!B1),VLOOKUP(Sheet1!B1,Sheet2!$B$2:$B$1000,1,FALSE))

    that way, if VLOOKUP doesn't find the value, and the value it searched for
    is an empty cell, it will return the empty blank....but if the value it
    serached for was not empty, it will return that value.


    "Richard" wrote:

    > Hi,
    >
    > I'm using vlookup to return a value, if there is one, from another
    > worksheet. The problem I'm encountering is that vlookup will return a zero if
    > there is no value to return. How do I get to return an empty cell if it
    > cannot find a value to return?
    >
    >
    > Thank You,


  4. #4
    Ken Hudson
    Guest

    RE: Vlookup returns a zero?

    Hi Richard,
    I believe that VLOOKUP will return a 0 if it finds the "Lookup" reference
    and the cell to be returned is empty. (Of course, it will also return a 0 if
    there is a zero in the cell.)

    This formula should change the 0 to an empty cell:

    =IF(VLOOKUP(A1.....)=0,"",VLOOKUP(A1...))


    --
    Ken Hudson


    "Richard" wrote:

    > Hi,
    >
    > I'm using vlookup to return a value, if there is one, from another
    > worksheet. The problem I'm encountering is that vlookup will return a zero if
    > there is no value to return. How do I get to return an empty cell if it
    > cannot find a value to return?
    >
    >
    > Thank You,


+ 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