+ Reply to Thread
Results 1 to 3 of 3

Vlookup returning 0 instead blank cell

  1. #1
    Registered User
    Join Date
    11-29-2013
    Location
    Portugal
    MS-Off Ver
    Excel 2010
    Posts
    28

    Vlookup returning 0 instead blank cell

    hii guys,

    Im facing a problem, i have this formula "=VLOOKUP($F$2;Base!$A$2:$FC$898;139;0)", and i dont want it to return "0" as value, how can i avoid that?

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Vlookup returning 0 instead blank cell

    Maybe:
    IF(ISBLANK(VLOOKUP($F$2;Base!$A$2:$FC$898;139;0)),"",VLOOKUP($F$2;Base!$A$2:$FC$898;139;0))

  3. #3
    Registered User
    Join Date
    11-29-2013
    Location
    Portugal
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Vlookup returning 0 instead blank cell

    It works, many thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Returning set text in a blank cell with VLOOKUP
    By hpofql in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-15-2013, 06:22 AM
  2. Excel 2007 : Returning blank cell if VLOOKUP has no value
    By SilverZero in forum Excel General
    Replies: 3
    Last Post: 06-23-2011, 06:59 PM
  3. vlookup returning blank cells?
    By ajwpurevisibility in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-09-2011, 11:36 AM
  4. vlookup returning blank for blank instead of 0
    By krayziez in forum Excel General
    Replies: 4
    Last Post: 07-31-2008, 11:58 AM
  5. Replies: 6
    Last Post: 10-27-2005, 11:05 AM

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