Spreadsheet: 170564d1343315950-vlookup-that-returns-multiple-values-from-a-prior-column-form
Sheet: Data Input

Title of Filter: |  | 1q12
Date: |  | 39641
Key Statistics:
 |  | Total | Amt > $0
Number of Records: |  | 115 | 1904-04-17 00:00:00
Total mUSD: |  |  | 1955-09-28 07:02:17.310000
Average Deal Size [mUSD]: |  |  | 1904-06-25 14:52:10.255000
Filter Criteria: |  | Include in Publications? |  |  |  | Date |  |  |  |  | Industry | [NAME] | MM Office |  | Trans. Type | Status | Company | Country | Country Region |  |  |  |  | Participant(s) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | First Exchange | First Exchange Region | Second Exchange | Second Exchange Region |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amt [USD] | Target / JV Partner | Comments
Operator |  | or |  |  |  | Between |  |  |  |  | or | or | or |  | or | or | or | or | or |  |  |  |  | and |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | or | or | or | or |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | between | or | or
Criteria 1 |  |  |  |  |  | 2012-01-01 00:00:00
[NAME] |  |  |  |  |  | 2012-04-01 00:00:00
 |  |  | Transaction Details |  |  |  |  |  |  |  |  |  |  |  |  |  | Company Details |  |  | Participants |  |  |  |  |  |  |  |  | Debt Transaction |  |  |  |  |  |  |  |  | Convertible Debt |  |  |  |  |  | Equity Transaction |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M&A / Lease
[NAME] | Related Record Num | Include in Publications | Date Entered | Date Transaction | Date Updated | Use Date | Date: Status = 'Done' or 'Cancelled' | Week No. | Prior Updates | Rec Edit Type | Industry | MM/MP Personnel | MM Office | Source | Transaction Type | Status | Company | Country | Country Region | Advisors | Leader(s) | Financial Institution(s) | Other Participant(s) | Participant(s) | Advisor Title | Leader [NAME] | Participant Title | Other Participant Title | Seniority | Amount [million Local Currency] | Price [Local Currency] | Interest Rate / Coupon Rate [%] | Maturity [YEAR] | Maturity [YEARS] | Yield [%] | Spread [bp] | Spread Basis | Conversion Price | Benchmark Price | Premium | Ratio | Shares Out. Pre Convertible Offering | blank | First Exchange | First Exchange Region | Second Exchange | Second Exchange Region | Exchange (combination) | Exchange Split | Primary Shares Issued [million] | Primary Shares [million Local Currency] | Greenshoe Shares Issued [million] | Greenshoe Shares [million Local Currency] | Secondary Shares Issued [million] | Secondary Shares Issued [million Local Currency] | Total Shares Raised [million Local Currency] | Total Equity Amount Raised [million Local Currency] | Total Shares pre Transaction [million] | Est. Share Dilution [%] | Issuance Price [per share] | Benchmark Price [per share] | Issuance Success [Price / Benchmark] | Subscription [x] | Total Transaction Amount [million Local Currency] | Local Currency ID | Exchange Rate [USD:Local Currency] | Total Proceeds [mUSD] | Target / New Company or Partners | Comments | Week No. for Date of Transaction | End
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D-BL |  | acme1 | usa |  |  |  |  |  | [NAME], Morgan Stanley |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D-CB |  | [NAME] | uk |  |  |  |  |  | [NAME], Bank of America |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-IPO |  | acme3 | china |  |  |  |  |  | JP Morgan, DNB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-FO |  | acme4 | singapore |  |  |  |  |  | DVB, Nordea, HSBC, |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-PP |  | acme1 | usa |  |  |  |  |  | Citi, Pareto, UBS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-Other |  | acme1 | usa |  |  |  |  |  | DBS, BNP