Spreadsheet: 46005d1244774556-find-value-matching-multiple-text-criteria-and-max-date-findlastexchangerate
Sheet: Trx

Destination | Date | Description | Currency | Trx Type | Foreign trx Amount | Real Exchange Rate | Derived Exch. Rate | Actual Native Amount Known | Native trx Amount
01. Kopenhagen Airport | 2009-01-05 00:00:00 | 1 | DKK | Daily Expenses | 54.5 | 0.1368807339449541 |  | yes | 7.46
02. St. Petersburg | 2009-01-05 00:00:00 | 3 | RUB | Daily Expenses | 432.2 | 0.02602961591855622 |  | yes | 11.25
02. St. Petersburg | 2009-01-05 00:00:00 | 4 | RUB | Withdrawal | 2000 | 0.02604 |  | yes | 52.08
02. St. Petersburg | 2009-01-06 00:00:00 | 5 | RUB | Withdrawal | 8000 | 0.025 |  | yes | 200
02. St. Petersburg | 2009-01-07 00:00:00 | 6 | RUB | Durables | 2338 | 0.02568006843455945 |  | yes | 60.04
02. St. Petersburg | 2009-01-07 00:00:00 | 7 | RUB | Durables | 5500 |  |  | no | 0
04. Moscow | 2009-01-08 00:00:00 | 9 | RUB | Withdrawal | 1800 |  |  | no | 0
04. Moscow | 2009-01-08 00:00:00 | 10 | RUB | Daily Expenses | 133.5 | 0.02546816479400749 |  | yes | 3.4
04. Moscow | 2009-01-08 00:00:00 | 11 | RUB | Daily Expenses | 278 | 0.02586330935251799 |  | yes | 7.19
04. Moscow | 2009-01-08 00:00:00 | 12 | RUB | Durables | 280 |  |  | no | 0
04. Moscow | 2009-01-09 00:00:00 | 13 | RUB | Withdrawal | 4000 | 0.0252475 |  | yes | 100.99
06. Irkutsk/Lake Baikal | 2009-01-10 00:00:00 | 15 | RUB | Withdrawal | 2500 |  |  | no | 0
06. Irkutsk/Lake Baikal | 2009-01-13 00:00:00 | 16 | RUB | Withdrawal | 3000 | 0.02467333333333333 |  | yes | 74.02
06. Irkutsk/Lake Baikal | 2009-01-14 00:00:00 | 17 | RUB | Withdrawal | 1500 | 0.02440666666666667 |  | yes | 36.61
06. Irkutsk/Lake Baikal | 2009-01-15 00:00:00 | 18 | RUB | Withdrawal | 4000 | 0.0241425 |  | yes | 96.57
08. Ulaanbaator | 2009-01-18 00:00:00 | 20 | MNT | Withdrawal | 25000 | 0.00076 |  | yes | 19
08. Ulaanbaator | 2009-01-18 00:00:00 | 21 | MNT | Withdrawal | 30000 | 0.0005690000000000001 |  | yes | 17.07
08. Ulaanbaator | 2009-01-19 00:00:00 | 22 | MNT | Withdrawal | 15000 | 0.0005693333333333333 |  | yes | 8.54
08. Ulaanbaator | 2009-01-19 00:00:00 | 23 | MNT | Daily Expenses | 21680 | 0.0005738007380073801 |  | yes | 12.44
08. Ulaanbaator | 2009-01-21 00:00:00 | 24 | MNT | Withdrawal | 40000 | 0.00058525 |  | yes | 23.41
08. Ulaanbaator | 2009-01-21 00:00:00 | 25 | MNT | Daily Expenses | 45203 | 0.0005864655000774286 |  | yes | 26.51
10. Beijing | 2009-01-23 00:00:00 | 27 | CNY | Withdrawal | 500 | 0.11518 |  | yes | 57.59
10. Beijing | 2009-01-24 00:00:00 | 28 | CNY | Withdrawal | 1000 | 0.11635 |  | yes | 116.35
10. Beijing | 2009-01-24 00:00:00 | 29 | CNY | Daily Expenses | 119 | 0.1163025210084034 |  | yes | 13.84
10. Beijing | 2009-01-26 00:00:00 | 30 | CNY | Travel Support | 100 |  |  | no | 0
10. Beijing | 2009-01-26 00:00:00 | 31 | CNY | Daily Expenses | 200 | 0.1144 |  | yes | 22.88
10. Beijing | 2009-01-26 00:00:00 | 32 | CNY | Withdrawal | 900 | 0.1159888888888889 |  | yes | 104.39
10. Beijing | 2009-01-28 00:00:00 | 33 | CNY | Daily Expenses | 58 | 0.1146551724137931 |  | yes | 6.65
10. Beijing | 2009-01-28 00:00:00 | 34 | CNY | Withdrawal | 900 | 0.1127555555555556 |  | yes | 101.48
10. Beijing | 2009-01-28 00:00:00 | 35 | CNY | Durables | 900 |  |  | no | 0
10. Beijing | 2009-01-29 00:00:00 | 36 | CNY | Withdrawal | 1500 | 0.11278 |  | yes | 169.17
10. Beijing | 2009-01-29 00:00:00 | 37 | CNY | Withdrawal | 1500 | 0.1121066666666667 |  | yes | 168.16
10. Beijing | 2009-01-29 00:00:00 | 38 | CNY | Withdrawal | 1500 | 0.1121066666666667 |  | yes | 168.16
10. Beijing | 2009-01-29 00:00:00 | 39 | CNY | Durables | 3200 |  |  | no | 0
10. Beijing | 2009-01-29 00:00:00 | 40 | CNY | Travel Support |  | #N/A |  | yes | 68.11
10. Beijing | 2009-01-30 00:00:00 | 41 | CNY | Daily Expenses | 30 | 0.1163333333333333 |  | yes | 3.49
10. Beijing | 2009-02-01 00:00:00 | 42 | CNY | Withdrawal | 900 | 0.1158444444444444 |  | yes | 104.26
10. Beijing | 2009-02-01 00:00:00 | 43 | CNY | Durables | 200 |  |  | no | 0
10. Beijing | 2009-02-01 00:00:00 | 44 | CNY | Daily Expenses | 85.9 | 0.1164144353899884 |  | yes | 10
10. Beijing | 2009-02-01 00:00:00 | 45 | CNY | Withdrawal | 900 | 0.1158444444444444 |  | yes | 104.26
10. Beijing | 2009-02-02 00:00:00 | 46 | CNY | Daily Expenses | 75 | 0.1168 |  | yes | 8.76
10. Beijing | 2009-02-03 00:00:00 | 47 | CNY | Withdrawal | 900 | 0.1168222222222222 |  | yes | 105.14
10. Beijing | 2009-02-03 00:00:00 | 48 | CNY | Travel Support | 90 |  |  | no | 0
10. Beijing | 2009-02-04 00:00:00 | 49 | CNY | Withdrawal | 1500 | 0.1157933333333333 |  | yes | 173.69
10. Beijing | 2009-02-04 00:00:00 | 50 | CNY | Travel Support | 508 |  |  | no | 0
10. Beijing | 2009-02-04 00:00:00 | 51 | EUR | Durables | 122.58 | 1 |  | yes | 122.58
10. Beijing | 2009-02-04 00:00:00 | 52 | CNY | Transport | 240 |  |  | no | 0
10. Beijing | 2009-02-04 00:00:00 | 53 | CNY | Transport | 26 |  |  | no | 0
10. Beijing | 2009-02-05 00:00:00 | 54 | CNY | Travel Support | 71 |  |  | no | 0