Hi I have VBA problem I hope you can help me with. I have a two arrays and for each value I want to search in the other array, and then copy the value from the second column in the second array into my first array.
I need to fill in column B in Sheet 1 with the corresponding name, leaving it blank if the code does not exist in the array. The problem is the values doesn't match up exactly, therefore I can't use VLOOKUP. I have done several attempts in Visual basic, with different approaches, all unsuccessfully. Example Sheet 1 Column A, Column B AA AB AAa ABb Sheet 2 Column A, Column B AA NAME_1 AB NAME_2 Should result in: Sheet 1 Column A, Column B AA NAME_1 AB NAME_2 AAa NAME_1 ABb NAME_2 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
