+ Reply to Thread
Results 1 to 10 of 10

vlookup not working properly

  1. #1
    Forum Contributor
    Join Date
    06-27-2012
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    164

    vlookup not working properly

    how can I match column A items with the correct match on column E to pull data from column F? what other formula combined with vlookup can i use?
    Attached Files Attached Files

  2. #2
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: vlookup not working properly

    The reason the Vlookup is not working is because you have no matches...your lookup data is all-Caps, the search data is mixed..(solvable with the proper function)....you have trailing spaces that may or may not equal the ones in the search data(use trim() function), you have "%" characters in some lookup data AND some search data...you could use the substitute function to get rid of those I suppose, but the underlying problem is that NONE of the data your looking for is in the form of where you are looking for it...it would probably be easier to change the lookup values first, THEN try to match it up...IMO anyways
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: vlookup not working properly

    I agree with Dred, in some cases you have extra characters in column A, but in others the extra characters are in D, so you cant even use wild cards to search for what you want
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Contributor
    Join Date
    06-27-2012
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    164

    Question Re: vlookup not working properly

    I tried it and it still doesn't work.
    Attached Files Attached Files
    Last edited by djmatok; 01-05-2013 at 09:13 PM.

  5. #5
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: vlookup not working properly

    upload what you have tried...telling us it does not work is not very helpful...if we can see what you have tried, then maybe we can get you going in the right direction at least

  6. #6
    Forum Contributor
    Join Date
    06-27-2012
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    164

    Re: vlookup not working properly

    thank you guys! I was thinking of combining the substitute formula but it didnt work for me. please see the above thread I added the ammended sample.

  7. #7
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: vlookup not working properly

    Okay, thats a start, but you still have "%" in both lists, and they don't seem to correspond to each other...if you substitute them to spaces(or ""), then use trim(can all be one formula) you'll be closer, there are still 1 or 2 other problems, but they may be easier to deal with if you get rid of the unnecessary stuff first
    This is something I am willing to look at at least now

  8. #8
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: vlookup not working properly

    duplicate post, self erased...looks like the weekend gremlins are hard at work
    Last edited by dredwolf; 01-05-2013 at 09:39 PM.

  9. #9
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: vlookup not working properly

    See if this works, i altered your formulas in columns B,C and F


    Edit-
    The one #NA error is there because there is no match at all for that entry
    Attached Files Attached Files
    Last edited by dredwolf; 01-05-2013 at 10:01 PM.

  10. #10
    Forum Contributor
    Join Date
    06-27-2012
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    164

    Re: vlookup not working properly

    Sorry Guys for not replying back as fast as I could. I really appreciate your help this was excellent solved my long problem

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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