Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jun 2007
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exceptions (2002)

    Hello. Strictly self-taught. Working with a table of 43 rows and 5 columns. Using VLookup to populate from 3 other tables. For some reason everything works well except for 3 records. There are no noticeable differences in the way info is obtained from the "feeder" tables. If there is a mistake, then the error, one would think, should show in all records, not just the 3. So I don't think my ineptness is to blame. Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Exceptions (2002)

    Welcome to Woody's Lounge!

    Without seeing the data, it is hard to say what causes the problem, of course. But I'd check that the values for which the lookup doesn't work don't contain extra spaces, either in the middle, or at the end. Trailing spaces, in particular, are easy to overlook.

    If you wish, you can attach a copy of your workbook to a reply, so that Loungers can investigate the problem directly. Remove or change sensitive information if necessary.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exceptions (2002)

    There are too many permutations of the ways that this can happen to make a guess. Are the lookup values numeric or strings? Is the lookup you are doing exact match or fuzzy lookup (the last parameter true or false). In other words, we will probably only be able to help if you can upload a workbook that shows the problem.
    Legare Coleman

  4. #4
    New Lounger
    Join Date
    Jun 2007
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exceptions (2002)

    Thank you for your prompt response. I'll go back to the drawing board and look for my mistakes. I usually find a few. wjm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •