+ Reply to Thread
Results 1 to 9 of 9

vlookup stopped working

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    worcester
    MS-Off Ver
    Excel 2010
    Posts
    17

    Question vlookup stopped working

    Hi,

    I am using this =IFERROR(VLOOKUP(A2,data!$A$2:$B$31,2,0),"") to pull in values from a table via a drop down in the Products column(A) that fills in the value in Cost column (B).

    Its been working fine but suddenly stopped and I have no idea why or how to fix it.

    Any help gratefully received.

    table.png

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,087

    Re: vlookup stopped working

    Not much anyone can do with a picture of a problem.

    Please upload a sample workbook that demonstrates the problem.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    05-29-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    84

    Re: vlookup stopped working

    Most of the time people have an issue with a Vlookup, I find that doing "Text to Columns" on the shared column in both spreadsheets fixes it. In this case, it appears to be column A in both sheets. Sometimes you may have the same number in 2 cells, but they are formatted differently so excel thinks that one is a value, while the other is a word or something so it won't link the 2 together. "Text to Columns" fixes this.

  4. #4
    Registered User
    Join Date
    11-26-2012
    Location
    worcester
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: vlookup stopped working

    Here you go :-)

    Attachment 208891

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: vlookup stopped working

    I get a message " Invalid attachment" trying to open your file . You probably missed the last step of attachment wizard ( load online or sthg).
    Perhaps try to re-post

  6. #6
    Registered User
    Join Date
    11-26-2012
    Location
    worcester
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: vlookup stopped working

    sliding_payment_ plan_forum.xlsx

    should have worked this time

  7. #7
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: vlookup stopped working

    This formula works OK for me:

    =IFERROR(VLOOKUP(A2,data!A$3:B$21,2,0),"")

    Some of the results of your current nested IF formula are incorrect.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  8. #8
    Registered User
    Join Date
    11-26-2012
    Location
    worcester
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: vlookup stopped working

    Quote Originally Posted by Tony Valko View Post
    This formula works OK for me:

    =IFERROR(VLOOKUP(A2,data!A$3:B$21,2,0),"")

    Some of the results of your current nested IF formula are incorrect.
    Thanks for that

    Do the selections work in column A where it defaults to 'choose product' and what errors are there?

  9. #9
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: vlookup stopped working

    There are no entries that say "choose product". They say "choose asset" and the formula returns a blank on those entries because there is no match on the data sheet. There is a "choose product" entry on the data sheet but the corresponding Cost cell is empty.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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