I can't get it work, it only returns N/A. I uploaded a sample... https://docs.google.com/leaf?id=0B0xyGw0Frro6Y2IzNTY4ZTUtOTU3Yi00NzE3LTk0ZmItYjliMDlkNGM2YTlh&sort=name&layout=list&num=50
On Dec 5, 3:38 pm, Marcus <marcus.ost...@gmail.com> wrote: > 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
