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?
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?
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
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
I tried it and it still doesn't work.
Last edited by djmatok; 01-05-2013 at 09:13 PM.
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
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.
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
duplicate post, self erased...looks like the weekend gremlins are hard at work
Last edited by dredwolf; 01-05-2013 at 09:39 PM.
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
Last edited by dredwolf; 01-05-2013 at 10:01 PM.
Sorry Guys for not replying back as fast as I could. I really appreciate your help this was excellent solved my long problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks