I would adise you to do the following: 1. Concatenate the three cells I.e., region, province and barangay in both the Sheets. 2. Now use index and match.
Let me know if this clear. Regards, Joe On Tuesday, September 6, 2011, John Alliage Tinio Morales < alliage.mora...@gmail.com> wrote: > Hi, I am John Alliage from GMA News, a broadcast network based in the Philippines. > > > > We’re doing a story about the conditional cash transfer in our country. I hope you could help me with my Excel query: > > > > I have two excel files, named BHS_REGIONALIZED and 2011_GEOGCODE_REGIONALIZED. > > > > The GEOGCODE file contains a geographic code, region, province, municipality, and barangay, whereas my BHS file contains only region, province and barangay. > > > > I would like to include the municipality record in the BHS file which doesn’t contain such information. I would like that all region, province and barangay columns match between the BHS_REGIONALIZED and GEOGCODE_REGIONALIZED files. One peculiar fact in our country’s geopolitical composition is that barangays from different municipalities and/or provinces can have the same name. For instance, the “San Roque” name can be found in at least a hundred barangays spread across municipalities and provinces. > > > > So I would like that all regions, provinces and barangays should match, so that the REAL municipality will be the result in the end. > > > > From here, it’s easy for me to include the geographical code for easy database construction. > > > > I will attach my files. I hope you could help me. > > > > -- > John Alliage Tinio Morales > Researcher > GMA News and Public Affairs > Mobile: 0915.846.8473 > Tel: (02) 982.7777 loc 1338 > Fax: (02) 982.7777 loc 1340 > > > > DISCLAIMER: > This Message may contain confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you received this message in error please notify your Mail Administrator and delete this message immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of GMA Network, Inc. > > -- > ---------------------------------------------------------------------------------- > 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/discussexcel > -- ---------------------------------------------------------------------------------- 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/discussexcel
