Spreadsheet: 153417d1335898121-match-multiple-cells-in-seperate-sheets-and-then-insert-cell-example
Sheet: Sheet2

2012-04-12 00:00:00 | China/Hong Kong | [NAME] is advising Kunlun Energy Co. Ltd., a Hong Kong natural resources company controlled by Chinese state-owned energy company PetroChina Co. Ltd., on a $1.35 billion share placement to fund expansion of its LNG activities. | Administrative law
2012-04-12 00:00:00 | China/Hong Kong | Jincheng, Tongda & Neal and [NAME] are acting for Aluminum Corp. of China Ltd. (also known as Chalco) on a $925 million bid for a 60-percent stake in SouthGobi Resources Ltd., a Vancouver-based mining company focused on Mongolia. | Admiralty law (or maritime law)
2012-04-12 00:00:00 | China/Hong Kong | [NAME] partners [NAME] and [NAME] are acting for private equity company CVC Capital Partners in a $641 million deal to acquire broadband and international dialling businesses from Hong Kong's City Telecom Ltd. | Agency law
2012-04-12 00:00:00 | China/Hong Kong | [NAME] is representing luxury hotel company Shangri-La Asia Ltd. in a $600 million offering of five-year notes. | Alcohol law
2012-04-12 00:00:00 | China/Hong Kong | Chinese construction machinery maker Zoomlion Heavy Industry Science and Technology Co. Ltd. has appointed aSimpson Thacher & Bartlett team including Hong Kong partners [NAME] and [NAME] to advise it on a $400 million notes issue by a special-purpose vehicle established by the company in Hong Kong. | Alternative dispute resolution
2012-04-12 00:00:00 | China/Hong Kong | Partners [NAME] and [NAME] are leading a WongPartnership team acting for a subsidiary of Singaporean schools operator Raffles Education Corp. Ltd. on the sale of land in Hebei province, China, to a golf course developer. Under the terms of the deal, Fenghe International Golf Club Co. Ltd. will pay $166 million for four plots of land on a university campus in Hebei. | Animal law
2012-04-12 00:00:00 | China/Hong Kong | Orrick, Herrington & Sutcliffe is acting for Chinese sportswear designer 361 Degrees International Ltd. in a $150 million convertible bond issue on the Singapore Exchange. | Antitrust law (or competition law)
2012-04-12 00:00:00 | China/Hong Kong | Skadden, Arps, Slate, Meagher & Flom Hong Kong partner [NAME] and Beijing's Han Kun Law Offices are advising Chinese online retailer Vipshop Holdings Ltd. on its $72 million initial public offering on the New York Stock Exchange. | Art law (or art and culture law)
2012-04-12 00:00:00 | Japan | Sidley Austin Chicago partners [NAME] and [NAME] are acting for Japan's Takeda Pharmaceutical Co. Ltd. in its planned acquisition of URL Pharma, Inc., a producer of gout medication based in Philadelphia. Osaka-based Takeda, whose products range from diabetes medication to insomnia treatments, will pay $800 million for URL. | Aviation law
2012-04-12 00:00:00 | Korea | London-based DLA Piper partner [NAME] is providing counsel to Samsung C&T Corp. on a deal that will give the Korean construction and trading company a 15-percent interest in a $4.8 billion carbon capture and storage project in Yorkshire, England. | Bankruptcy law
2012-04-12 00:00:00 | Mongolia | Davis Polk & Wardwell Hong Kong partners [NAME] and [NAME] are advising Mongolian Mining Corp. on a $600 million global issue of high-yield notes. | Business law (or commercial law)
2012-04-12 00:00:00 | Southeast Asia | Malaysian casino operator [NAME]. has built on its $1.4 billion perpetual bond issue earlier this year with a $397 million follow-on offering.  Allen & Gledhill partners [NAME] and [NAME] are advising Genting on Singapore law | Business organizations law (or companies law)
2012-04-12 00:00:00 | Southeast Asia | Vietnamese property developer Vincom JSC is issuing five-year convertible bonds worth up to $250 million, which is being advised by [NAME]. | Case law
2012-04-12 00:00:00 | Southeast Asia | Allen & Gledhill partner [NAME] is advising Indonesian property developer PT [NAME]. on a $150 million offering of senior notes via a Singapore subsidiary. | Civil law
2012-04-12 00:00:00 | Australia | Australian haulage and crane company McAleese Transport Pty Ltd. has appointed Freehills Sydney partners [NAME] and [NAME] to advise on its purchase of International Energy Services, a Camberwell, Victoria-based group of fuel transport and handling businesses, for around $300 million. | Corporate law (or company law)
2012-04-05 00:00:00 | China/Hong Kong | China Minsheng Banking Corp. Ltd. has appointed [NAME] as lead counsel on its $1.4 billion sale of shares to bolster its capital base in advance of new capitalization rules being introduced in China. | Computer law
2012-04-05 00:00:00 | China/Hong Kong | [NAME] is advising Kunlun Energy Co. Ltd., a Hong Kong-based natural resources company, on a $1.35 billion share placement. | Conflict of law (or private international law)
2012-04-05 00:00:00 | China/Hong Kong | [NAME] Beijing corporate partner [NAME] is advising state-owned export credit agency The Export-Import Bank of China on a $635 million bond issue. | Constitutional law
2012-04-05 00:00:00 | China/Hong Kong | Stamford Law Corp. is representing Ocean Sky International Ltd., on its reverse takeover of Chinese property developer ChiwayLand Group. [NAME] will pay $295 million for ChiwayLand. | Construction law
2012-04-05 00:00:00 | Singapore | WongPartnership's [NAME] is leading a team providing counsel to U.S. agriculture giant Cargill, Inc. in relation to an Asia-based revolving syndicated loan to refinance $1.25 billion of existing debt. | Consumer law
2012-04-05 00:00:00 | Singapore | LaSalle Investment Management, Inc. is selling its 95-percent stake in the Twenty Anson office building in Singapore to CapitaCommercial Trust, a real estate investment trust. CapitaCommercial is paying $324 million for the building, which was erected in downtown Singapore in 2009. Rodyk & Davidson is advising CapitaCommercial. | Contract law
2012-04-05 00:00:00 | Singapore | Simpson Thacher & Bartlett and WongPartnership are advising MMI International Ltd., the largest supplier of components to U.S. hard disk drive maker Seagate Technology PLC, on a $300 million senior secured notes issue. | Copyright law
2012-04-05 00:00:00 | Singapore | WongPartnership has fielded five partners to advise on a $278 million perpetual bond issue by Mapletree Logistics Trust, a Singapore-based investment trust specializing in logistics-related real estate. | Criminal law