Results 1 to 4 of 4

Thread: Vlookup

  1. #1
    Star Lounger
    Join Date
    Jun 2010
    Location
    Quincy, MA
    Posts
    62
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Vlookup

    Hello,
    I'm using VLOOKUP to identify matches bewtween two tabs of data on an spreadsheet. Because the data comes from two different systems and there's no logical key, the formula is not returning any hits. I'm wondering if there is a formula that will allow me to to scan for say the first 6 characters which still means wading through [likely] false positives, but it will cetainly help chop things down to size. Thanks

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    Thanos:

    Can you provide a simple example of data and what you expect as a final result. If you are trying to find items that are in both data sets Vlookup would not be the best approach. Perhaps attaching a simple workbook with an example of the data in one set, data in the other set, and desired results.

    TD

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Check out the functions "NearMatch" and "NearMatch2" (and their descriptions) at http://windowssecrets.com/forums/sho...l=1#post245036

    Steve

  4. #4
    Star Lounger
    Join Date
    Jun 2010
    Location
    Quincy, MA
    Posts
    62
    Thanks
    2
    Thanked 0 Times in 0 Posts
    TD & Steve - thank you for your responses, greatly appreciated. I think Stev's response is realy what I need, but since yesterday and today, a buddy with Access skills was able to bang this out for me. Please consider this item closed. Thanks agaim,

Posting Permissions

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