Spreadsheet: 68844d1269379337-two-condition-vlookup-condvlookexamp
Sheet: Price

AEP |  | PAN |  | DAC |  | AEE |  | AZA |  | AZE |  | OMIK
Date | PX_LAST | Date | PX_LAST | Date | PX_LAST | Date | PX_LAST | Date | PX_LAST | Date | PX_LAST | Date | PX_LAST
2009-12-11 00:00:00 | 35.58 | 2009-12-11 00:00:00 | 35.58 | 2009-12-11 00:00:00 | 35.58 | 2009-12-11 00:00:00 | 35.58 | 2009-12-11 00:00:00 | 35.58 | 2009-12-11 00:00:00 | 35.58 | 2009-12-11 00:00:00 | 35.58
2009-12-14 00:00:00 | 35.41 | 2009-12-14 00:00:00 | 35.41 | 2009-12-14 00:00:00 | 35.41 | 2009-12-14 00:00:00 | 35.41 | 2009-12-14 00:00:00 | 35.41 | 2009-12-14 00:00:00 | 35.41 | 2009-12-14 00:00:00 | 35.41
2009-12-15 00:00:00 | 35.06 | 2009-12-15 00:00:00 | 35.06 | 2009-12-15 00:00:00 | 35.06 | 2009-12-15 00:00:00 | 35.06 | 2009-12-15 00:00:00 | 35.06 | 2009-12-15 00:00:00 | 35.06 | 2009-12-15 00:00:00 | 35.06
2009-12-16 00:00:00 | 35.18 | 2009-12-16 00:00:00 | 35.18 | 2009-12-16 00:00:00 | 35.18 | 2009-12-16 00:00:00 | 35.18 | 2009-12-16 00:00:00 | 35.18 | 2009-12-16 00:00:00 | 35.18 | 2009-12-16 00:00:00 | 35.18
2009-12-17 00:00:00 | 34.82 | 2009-12-17 00:00:00 | 34.82 | 2009-12-17 00:00:00 | 34.82 | 2009-12-17 00:00:00 | 34.82 | 2009-12-17 00:00:00 | 34.82 | 2009-12-17 00:00:00 | 34.82 | 2009-12-17 00:00:00 | 54.78
2009-12-18 00:00:00 | 35.08 | 2009-12-18 00:00:00 | 35.08 | 2009-12-18 00:00:00 | 35.08 | 2009-12-18 00:00:00 | 35.08 | 2009-12-18 00:00:00 | 35.08 | 2009-12-18 00:00:00 | 35.08 | 2009-12-18 00:00:00 | 35.08
2009-12-21 00:00:00 | 35.18 | 2009-12-21 00:00:00 | 35.18 | 2009-12-21 00:00:00 | 35.18 | 2009-12-21 00:00:00 | 35.18 | 2009-12-21 00:00:00 | 35.18 | 2009-12-21 00:00:00 | 35.18 | 2009-12-21 00:00:00 | 35.18
2009-12-22 00:00:00 | 34.84 | 2009-12-22 00:00:00 | 34.84 | 2009-12-22 00:00:00 | 34.84 | 2009-12-22 00:00:00 | 34.84 | 2009-12-22 00:00:00 | 34.84 | 2009-12-22 00:00:00 | 34.84 | 2009-12-22 00:00:00 | 34.84
2009-12-23 00:00:00 | 34.73 | 2009-12-23 00:00:00 | 34.73 | 2009-12-23 00:00:00 | 34.73 | 2009-12-23 00:00:00 | 34.73 | 2009-12-23 00:00:00 | 34.73 | 2009-12-23 00:00:00 | 34.73 | 2009-12-23 00:00:00 | 34.73
2009-12-24 00:00:00 | 35.12 | 2009-12-24 00:00:00 | 35.12 | 2009-12-24 00:00:00 | 35.12 | 2009-12-24 00:00:00 | 35.12 | 2009-12-24 00:00:00 | 35.12 | 2009-12-24 00:00:00 | 35.12 | 2009-12-24 00:00:00 | 35.12
2009-12-28 00:00:00 | 35.03 | 2009-12-28 00:00:00 | 35.03 | 2009-12-28 00:00:00 | 35.03 | 2009-12-28 00:00:00 | 35.03 | 2009-12-28 00:00:00 | 35.03 | 2009-12-28 00:00:00 | 35.03 | 2009-12-28 00:00:00 | 35.03
2009-12-29 00:00:00 | 35.32 | 2009-12-29 00:00:00 | 35.32 | 2009-12-29 00:00:00 | 35.32 | 2009-12-29 00:00:00 | 35.32 | 2009-12-29 00:00:00 | 35.32 | 2009-12-29 00:00:00 | 35.32 | 2009-12-29 00:00:00 | 35.32
2009-12-30 00:00:00 | 35.26 | 2009-12-30 00:00:00 | 35.26 | 2009-12-30 00:00:00 | 35.26 | 2009-12-30 00:00:00 | 35.26 | 2009-12-30 00:00:00 | 35.26 | 2009-12-30 00:00:00 | 35.26 | 2009-12-30 00:00:00 | 35.26
2009-12-31 00:00:00 | 34.79 | 2009-12-31 00:00:00 | 34.79 | 2009-12-31 00:00:00 | 34.79 | 2009-12-31 00:00:00 | 34.79 | 2009-12-31 00:00:00 | 34.79 | 2009-12-31 00:00:00 | 34.79 | 2009-12-31 00:00:00 | 34.79
2010-01-04 00:00:00 | 34.94 | 2010-01-04 00:00:00 | 34.94 | 2010-01-04 00:00:00 | 34.94 | 2010-01-04 00:00:00 | 34.94 | 2010-01-04 00:00:00 | 34.94 | 2010-01-04 00:00:00 | 34.94 | 2010-01-04 00:00:00 | 34.94
2010-01-05 00:00:00 | 34.54 | 2010-01-05 00:00:00 | 34.54 | 2010-01-05 00:00:00 | 34.54 | 2010-01-05 00:00:00 | 34.54 | 2010-01-05 00:00:00 | 34.54 | 2010-01-05 00:00:00 | 34.54 | 2010-01-05 00:00:00 | 34.54
2010-01-06 00:00:00 | 34.89 | 2010-01-06 00:00:00 | 34.89 | 2010-01-06 00:00:00 | 34.89 | 2010-01-06 00:00:00 | 34.89 | 2010-01-06 00:00:00 | 34.89 | 2010-01-06 00:00:00 | 34.89 | 2010-01-06 00:00:00 | 34.89
2010-01-07 00:00:00 | 35.19 | 2010-01-07 00:00:00 | 35.19 | 2010-01-07 00:00:00 | 35.19 | 2010-01-07 00:00:00 | 35.19 | 2010-01-07 00:00:00 | 35.19 | 2010-01-07 00:00:00 | 35.19 | 2010-01-07 00:00:00 | 35.19
2010-01-08 00:00:00 | 35.61 | 2010-01-08 00:00:00 | 35.61 | 2010-01-08 00:00:00 | 35.61 | 2010-01-08 00:00:00 | 35.61 | 2010-01-08 00:00:00 | 35.61 | 2010-01-08 00:00:00 | 35.61 | 2010-01-08 00:00:00 | 35.61
2010-01-11 00:00:00 | 35.98 | 2010-01-11 00:00:00 | 35.98 | 2010-01-11 00:00:00 | 35.98 | 2010-01-11 00:00:00 | 35.98 | 2010-01-11 00:00:00 | 35.98 | 2010-01-11 00:00:00 | 35.98 | 2010-01-11 00:00:00 | 35.98
2010-01-12 00:00:00 | 35.62 | 2010-01-12 00:00:00 | 35.62 | 2010-01-12 00:00:00 | 35.62 | 2010-01-12 00:00:00 | 35.62 | 2010-01-12 00:00:00 | 35.62 | 2010-01-12 00:00:00 | 35.62 | 2010-01-12 00:00:00 | 35.62
2010-01-13 00:00:00 | 36.06 | 2010-01-13 00:00:00 | 36.06 | 2010-01-13 00:00:00 | 36.06 | 2010-01-13 00:00:00 | 36.06 | 2010-01-13 00:00:00 | 36.06 | 2010-01-13 00:00:00 | 36.06 | 2010-01-13 00:00:00 | 36.06
2010-01-14 00:00:00 | 36.2 | 2010-01-14 00:00:00 | 36.2 | 2010-01-14 00:00:00 | 36.2 | 2010-01-14 00:00:00 | 36.2 | 2010-01-14 00:00:00 | 36.2 | 2010-01-14 00:00:00 | 36.2 | 2010-01-14 00:00:00 | 36.2
2010-01-15 00:00:00 | 36.01 | 2010-01-15 00:00:00 | 36.01 | 2010-01-15 00:00:00 | 36.01 | 2010-01-15 00:00:00 | 36.01 | 2010-01-15 00:00:00 | 36.01 | 2010-01-15 00:00:00 | 36.01 | 2010-01-15 00:00:00 | 36.01
2010-01-19 00:00:00 | 36.44 | 2010-01-19 00:00:00 | 36.44 | 2010-01-19 00:00:00 | 36.44 | 2010-01-19 00:00:00 | 0.234 | 2010-01-19 00:00:00 | 36.44 | 2010-01-19 00:00:00 | 36.44 | 2010-01-19 00:00:00 | 36.44
2010-01-20 00:00:00 | 36.52 | 2010-01-20 00:00:00 | 36.52 | 2010-01-20 00:00:00 | 36.52 | 2010-01-20 00:00:00 | 36.52 | 2010-01-20 00:00:00 | 36.52 | 2010-01-20 00:00:00 | 36.52 | 2010-01-20 00:00:00 | 36.52
2010-01-21 00:00:00 | 36.11 | 2010-01-21 00:00:00 | 36.11 | 2010-01-21 00:00:00 | 36.11 | 2010-01-21 00:00:00 | 36.11 | 2010-01-21 00:00:00 | 36.11 | 2010-01-21 00:00:00 | 36.11 | 2010-01-21 00:00:00 | 36.11
2010-01-22 00:00:00 | 35.42 | 2010-01-22 00:00:00 | 35.42 | 2010-01-22 00:00:00 | 35.42 | 2010-01-22 00:00:00 | 35.42 | 2010-01-22 00:00:00 | 35.42 | 2010-01-22 00:00:00 | 35.42 | 2010-01-22 00:00:00 | 35.42
2010-01-25 00:00:00 | 35.62 | 2010-01-25 00:00:00 | 35.62 | 2010-01-25 00:00:00 | 35.62 | 2010-01-25 00:00:00 | 35.62 | 2010-01-25 00:00:00 | 35.62 | 2010-01-25 00:00:00 | 35.62 | 2010-01-25 00:00:00 | 35.62
2010-01-26 00:00:00 | 35.61 | 2010-01-26 00:00:00 | 35.61 | 2010-01-26 00:00:00 | 35.61 | 2010-01-26 00:00:00 | 35.61 | 2010-01-26 00:00:00 | 35.61 | 2010-01-26 00:00:00 | 35.61 | 2010-01-26 00:00:00 | 35.61
2010-01-27 00:00:00 | 35.53 | 2010-01-27 00:00:00 | 35.53 | 2010-01-27 00:00:00 | 35.53 | 2010-01-27 00:00:00 | 35.53 | 2010-01-27 00:00:00 | 35.53 | 2010-01-27 00:00:00 | 35.53 | 2010-01-27 00:00:00 | 35.53
2010-01-28 00:00:00 | 35.06 | 2010-01-28 00:00:00 | 35.06 | 2010-01-28 00:00:00 | 35.06 | 2010-01-28 00:00:00 | 35.06 | 2010-01-28 00:00:00 | 35.06 | 2010-01-28 00:00:00 | 35.06 | 2010-01-28 00:00:00 | 35.06
2010-01-29 00:00:00 | 34.65 | 2010-01-29 00:00:00 | 34.65 | 2010-01-29 00:00:00 | 34.65 | 2010-01-29 00:00:00 | 34.65 | 2010-01-29 00:00:00 | 34.65 | 2010-01-29 00:00:00 | 34.65 | 2010-01-29 00:00:00 | 34.65