+ Reply to Thread
Results 1 to 2 of 2

vlookup Issue

  1. #1
    Registered User
    Join Date
    03-23-2013
    Location
    lincoln england
    MS-Off Ver
    2010
    Posts
    75

    vlookup Issue

    Hi

    I have attached a broken down example of a sheet I am using, I am not to familiar with vlookup but I managed to get it to work for what I needed.

    If you got to cell B9014 you will see the code which has been filled down as you will see.

    In cells B9038, B9039, B9040, B9041 it is displaying the wrong data and I cannot work out why. You will see easily what should be there from the data in the range A2:B5000 (actually more like B800).

    Any help would be greatly appreciated thanks,

    Dan W
    Attached Files Attached Files

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: vlookup Issue

    maybe use this starting in row 9014 and copy down...

    Please Login or Register  to view this content.
    EDIT: Just a note - you should use $A$2:$B$5000 in your LOOKUP also because when you copy down the numbers will increment not just the A9014 but also the A2:B5000
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

+ 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. vlookup issue
    By ascottbag in forum Excel General
    Replies: 8
    Last Post: 02-13-2011, 03:53 PM
  2. Vlookup issue
    By philiasfogg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-26-2009, 06:43 AM
  3. VLOOKUP Issue
    By NJT in forum Excel General
    Replies: 4
    Last Post: 03-07-2009, 06:47 AM
  4. VLOOKUP Issue
    By FM1 in forum Excel General
    Replies: 2
    Last Post: 03-12-2008, 06:52 PM
  5. Vlookup Issue
    By babypink in forum Excel General
    Replies: 7
    Last Post: 10-16-2007, 08:20 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