+ Reply to Thread
Results 1 to 5 of 5

Vlookup returning zero when there is a value in that cell.

  1. #1
    Registered User
    Join Date
    09-07-2017
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    35

    Vlookup returning zero when there is a value in that cell.

    Hi All

    I am looking up columns from one workbook to another.

    So in Book1 Column A I need data from Book2 Column A then Column B than C etc...

    I have looked up Column A & Column B from Book2 as above and it worked fine however, Column C & D are returning zero where there is information on the cells.

    There cant be anything wrong with data in Book1 column as I did get proper results on first two look ups.

    Anyone?

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Vlookup returning zero when there is a value in that cell.

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.
    Glenn



  3. #3
    Registered User
    Join Date
    09-07-2017
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    35

    Re: Vlookup returning zero when there is a value in that cell.

    Please see sample file attached.
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Vlookup returning zero when there is a value in that cell.

    3000 rows and no indication of where we are supposed to look.

    Come on... a bit more information, please.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Vlookup returning zero when there is a value in that cell.

    The formulae in Book 2 were referring to an external sheet with VERY different layout... data starting in J.

    This MIGHT be whjat you want for your sample, but it's ard to tell as the column headings don't quite tally.

    Variants of this;

    =IFERROR(1/(1/VLOOKUP($A2,BOOK1!$A:$AA,18,0)),"")

    have been used in the pale green cells.
    Attached Files Attached Files

+ 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] (Vlookup)Returning 0 If cell is empty
    By LeeBillington in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-17-2018, 02:15 PM
  2. [SOLVED] Vlookup returning 0 instead blank cell
    By startuga in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2013, 05:52 AM
  3. Vlookup - Returning value from Merge Cell
    By dluhut in forum Excel General
    Replies: 1
    Last Post: 06-20-2012, 01:07 PM
  4. VLOOKUP not returning the correct value in cell
    By RyanEAS in forum Excel General
    Replies: 5
    Last Post: 03-07-2012, 02:05 PM
  5. 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
  6. vlookup returning value one cell above what it should?
    By thumper300zx in forum Excel General
    Replies: 5
    Last Post: 11-25-2010, 12:03 PM
  7. VLOOKUP returning wrong cell?
    By Dluxe in forum Excel General
    Replies: 5
    Last Post: 05-31-2005, 01:05 PM

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