Spreadsheet: 87353d1287162794-combining-if-and-lookup-for-complicated-data-sample-is-attached-sample
Sheet: Sheet1

 |  | year end |  |  | year end value |  |  |  |  |  | MV
dscode | name | 2007 | 2008 | 2009 | 2007 | 2008 | 2009 |  | dscode | name | 2007 | 2008 | 2009
134982 | MCBRIDE | 2007-06-30 00:00:00 | 2008-06-30 00:00:00 | 2009-06-30 00:00:00 | 39263 | 39629 | 39994 |  | 134982 | MCBRIDE | 313.17 | ?? | ??
135024 | MITSUBISHI ESTATES (XSQ) DEAD - 01/10/08 | 2007-03-31 00:00:00 | 2008-03-31 00:00:00 | 2009-03-31 00:00:00 | 39172 | 39538 | 39903 |  | 135024 | MITSUBISHI ESTATES (XSQ) DEAD - 01/10/08 | 1610633 | ?? | ??
135025 | MITSUBISHI HEAVY (XSQ) DEAD - 01/10/08 | 2007-03-31 00:00:00 | 2008-03-31 00:00:00 | 2009-03-31 00:00:00 | 39172 | 39538 | 39903 |  | 135025 | MITSUBISHI HEAVY (XSQ) DEAD - 01/10/08 | 1035709 | ?? | ??
135030 | MITSUBISHI MOTORS (XSQ) DEAD - 01/10/08 | 2007-03-31 00:00:00 | 2008-03-31 00:00:00 | 2009-03-31 00:00:00 | 39172 | 39538 | 39903 |  | 135030 | MITSUBISHI MOTORS (XSQ) DEAD - 01/10/08 | 1455253 | ?? | ??
135031 | MITSUI & COMPANY (XSQ) DEAD - 01/10/08 | 2007-03-31 00:00:00 | 2008-03-31 00:00:00 | 2009-03-31 00:00:00 | 39172 | 39538 | 39903 |  | 135031 | MITSUI & COMPANY (XSQ) DEAD - 01/10/08 | 1656415 | ?? | ??
135032 | MITSUI FUDOSAN (XSQ) DEAD - 01/10/08 | 2007-03-31 00:00:00 | 2008-06-30 00:00:00 | 2009-06-30 00:00:00 | 39172 | 39538 | 39903 |  | 135032 | MITSUI FUDOSAN (XSQ) DEAD - 01/10/08 | 2782658 | ?? | ??
135044 | MITSUI SUMIT.IN.CO.(XSQ) DEAD - 04/04/08 | 2007-03-31 00:00:00 | 2008-06-30 00:00:00 | 2009-06-30 00:00:00 | 39172 | 39538 | 39903 |  | 135044 | MITSUI SUMIT.IN.CO.(XSQ) DEAD - 04/04/08 | 1419366 | ?? | ??
135046 | MITSUKOSHI (XSQ) DEAD - 04/04/08 | 2007-02-28 00:00:00 | 2008-02-29 00:00:00 | NA | 39141 | 39507 | NA |  | 135046 | MITSUKOSHI (XSQ) DEAD - 04/04/08 | 172532.3 | ?? | ??
MV |  | 38748 | 38776 | 38807 | 38835 | 38868 | 38898 | 38929 | 38960 | 38989 | 39021 | 39051 | 39082 | 39113 | 39141 | 39171 | 39202 | 39233 | 39262 | 39294 | 39325 | 39353 | 39386 | 39416 | 39447 | 39478 | 39507 | 39538 | 39568 | 39598 | 39629 | 39660 | 39689 | 39721 | 39752 | 39780 | 39813 | 39843 | 39871 | 39903 | 39933 | 39962 | 39994 | 40025 | 40056 | 40086 | 40116 | 40147 | 40178 | 40207 | 40235 | 40268 | 40298 | 40329 | 40359 | 40389
code | name | 2006-01-31 00:00:00 | 2006-02-28 00:00:00 | 2006-03-31 00:00:00 | 2006-04-28 00:00:00 | 2006-05-31 00:00:00 | 2006-06-30 00:00:00 | 2006-07-31 00:00:00 | 2006-08-31 00:00:00 | 2006-09-29 00:00:00 | 2006-10-31 00:00:00 | 2006-11-30 00:00:00 | 2006-12-31 00:00:00 | 2007-01-31 00:00:00 | 2007-02-28 00:00:00 | 2007-03-30 00:00:00 | 2007-04-30 00:00:00 | 2007-05-31 00:00:00 | 2007-06-29 00:00:00 | 2007-07-31 00:00:00 | 2007-08-31 00:00:00 | 2007-09-28 00:00:00 | 2007-10-31 00:00:00 | 2007-11-30 00:00:00 | 2007-12-31 00:00:00 | 2008-01-31 00:00:00 | 2008-02-29 00:00:00 | 2008-03-31 00:00:00 | 2008-04-30 00:00:00 | 2008-05-30 00:00:00 | 2008-06-30 00:00:00 | 2008-07-31 00:00:00 | 2008-08-29 00:00:00 | 2008-09-30 00:00:00 | 2008-10-31 00:00:00 | 2008-11-28 00:00:00 | 2008-12-31 00:00:00 | 2009-01-30 00:00:00 | 2009-02-27 00:00:00 | 2009-03-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-29 00:00:00 | 2009-06-30 00:00:00 | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 | 2009-09-30 00:00:00 | 2009-10-30 00:00:00 | 2009-11-30 00:00:00 | 2009-12-31 00:00:00 | 2010-01-29 00:00:00 | 2010-02-26 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 | 2010-07-30 00:00:00 | merge
134982 | MCBRIDE | 293.46 | 297.6 | 294.05 | 296.27 | 302.91 | 313.9 | 293.15 | 291.38 | 303.75 | 313.08 | 313.53 | 349.52 | 341.52 | 384.58 | 426.01 | 422.9 | 462.43 | 389.58 | 344.71 | 347 | 313.98 | 313.17 | 284.33 | 196.46 | 174.88 | 169.47 | 189.3 | 189.3 | 170.37 | 139.27 | 179.84 | 208.68 | 180.29 | 227.16 | 225.36 | 219.95 | 226.26 | 201.92 | 208.23 | 227.16 | 242.94 | 261.42 | 263.22 | 261.06 | 344.34 | 401.58 | 376.33 | 381.56 | 393.1 | 432.5 | 410.89 | 337.9 | 336.1 | 234.28 | 250.87 | 3
135024 | MITSUBISHI ESTATES (XSQ) DEAD - 01/10/08 | 1529981 | 1555620 | 1597434 | 1597434 | 1597954 | 1597963 | 1597963 | 1601696 | 1601696 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 1610633 | 3
135025 | MITSUBISHI HEAVY (XSQ) DEAD - 01/10/08 | 1034022 | 1034022 | 1034022 | 1034022 | 1034022 | 1034022 | 1034022 | 1034022 | 1034022 | 1034022 | 1034022 | 1034022 | 1034022 | 1034022 | 1034022 | 1034022 | 1034022 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 1035709 | 3
135030 | MITSUBISHI MOTORS (XSQ) DEAD - 01/10/08 | 1438042 | 1438049 | 1455234 | 1455234 | 1455251 | 1455251 | 1455251 | 1455251 | 1455251 | 1455251 | 1455251 | 1455251 | 1455251 | 1455251 | 1455251 | 1455251 | 1455251 | 1455251 | 1455253 | 1455253 | 1455253 | 1455253 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 1467542 | 3
135031 | MITSUI & COMPANY (XSQ) DEAD - 01/10/08 | 1450499 | 1569462 | 1578391 | 1578391 | 1578426 | 1578428 | 1578437 | 1578437 | 1578437 | 1578458 | 1578458 | 1578458 | 1581994 | 1607630 | 1607630 | 1635597 | 1637101 | 1637101 | 1656415 | 1656808 | 1656808 | 1663118 | 1663710 | 1663758 | 1663999 | 1664023 | 1665467 | 1665467 | 1665467 | 1667798 | 1669448 | 1669448 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 1669635 | 3
135032 | MITSUI FUDOSAN (XSQ) DEAD - 01/10/08 | 2054689 | 2137455 | 2379846 | 2255566 | 2023751 | 2191222 | 2146269 | 2319028 | 2366625 | 2564946 | 2397475 | 2560539 | 2758859 | 2882259 | 3049730 | 3180180 | 3317683 | 3047526 | 2782658 | 2668513 | 2811745 | 2785302 | 2505890 | 2170949 | 2126877 | 1903877 | 1743458 | 2304926 | 2303163 | 1999071 | 2172712 | 2027276 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 1731999 | 3
135044 | MITSUI SUMIT.IN.CO.(XSQ) DEAD - 04/04/08 | 1418610 | 1418610 | 1418610 | 1418610 | 1418610 | 1418610 | 1418610 | 1418610 | 1418610 | 1418610 | 1418610 | 1418610 | 1418610 | 1418610 | 1418610 | 1418610 | 1418610 | 1419366 | 1419366 | 1419366 | 1419366 | 1419366 | 1419366 | 1419366 | 1419366 | 1419366 | 1419366 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 395198.8 | 3
135046 | MITSUKOSHI (XSQ) DEAD - 04/04/08 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 172532.3 | 3