Spreadsheet: 115657d1311195506-vlookup-not-returning-correct-results-lien-book-example-
Sheet: MCID Adjusted Values 2011.07.14

1 | 2 | 3 | 4 | 5 |  |  |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75
Townhome | 13808 |  |  |  |  |  |  |  | 8/1/05 - 7/31/06
Duplex $299,999 or less | 11987 |  |  | yellow means original values |  |  |  |  | 8/1/06 - 7/31/07
Duplex $300K-$349K | 13808 |  |  | green means changed values due to sale on property |  |  |  |  | 8/1/07 - 7/31/08
SF - Medium | 16338 |  |  |  |  |  |  |  | 8/1/08 - 7/31/09
SF - Large (outside) | 19257 |  |  |  |  |  |  |  | 8/1/09 - 7/31/10
SF - Large | 17449 |  |  |  |  |  |  | Current Tax Roll Year = | 8/1/10 - 7/31/11
 |  |  |  |  |  |  |  |  |  |  |  | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest
 | Parcel ID |  |  | Unit Legend |  |  |  | Sales Price | Sale Date | Series 2006A Total Debt Per Lot |  | 2008 | 2008 | 2009 | 2009 | 2010 | 2010 | 2011 | 2011 | 2012 | 2012 | 2013 | 2013 | 2014 | 2014 | 2015 | 2015 | 2016 | 2016 | 2017 | 2017 | 2018 | 2018 | 2019 | 2019 | 2020 | 2020 | 2021 | 2021 | 2022 | 2022 | 2023 | 2023 | 2024 | 2024 | 2025 | 2025 | 2026 | 2026 | 2027 | 2027 | 2028 | 2028 | 2029 | 2029 | 2030 | 2030 | 2031 | 2031 | 2032 | 2032 | 2033 | 2033 | 2034 | 2034 | 2035 | 2035 | 2036 | 2036 | 2037 | 2037 |  | Check Figure Principal
House 1 |  |  |  | Duplex $300K-$349K |  |  |  | 247300 | 2010-08-06 00:00:00 |  | Owner portion
House 1 |  |  |  | Duplex $300K-$349K |  |  |  | 247300 | 2010-08-06 00:00:00 |  | Developer portion
House 2 |  |  |  | Duplex $300K-$349K |  |  |  | 214800 | 2010-08-13 00:00:00 |  | Owner portion
House 2 |  |  |  | Duplex $300K-$349K |  |  |  | 214800 | 2010-08-13 00:00:00 |  | Developer portion
House 3 |  |  |  | SF - Medium |  |  |  | 316900 | 2010-08-16 00:00:00 |  | Owner portion
House 3 |  |  |  | SF - Medium |  |  |  | 316900 | 2010-08-16 00:00:00 |  | Developer portion
House 4 |  |  |  | Duplex $300K-$349K |  |  |  | 234900 | 2010-08-24 00:00:00 |  | Owner portion
House 4 |  |  |  | Duplex $300K-$349K |  |  |  | 234900 | 2010-08-24 00:00:00 |  | Developer portion
House 5 |  |  |  | Duplex $300K-$349K |  |  |  | 214800 | 2010-12-03 00:00:00 |  | Owner portion
House 5 |  |  |  | Duplex $300K-$349K |  |  |  | 214800 | 2010-12-03 00:00:00 |  | Developer portion
House 6 |  |  |  | SF - Large |  |  |  | 435000 | 2010-12-03 00:00:00 |  | Owner portion
House 6 |  |  |  | SF - Large |  |  |  | 435000 | 2010-12-03 00:00:00 |  | Developer portion
House 7 |  |  |  | SF - Large |  |  |  | 365000 | 2010-12-07 00:00:00 |  | Owner portion
House 7 |  |  |  | SF - Large |  |  |  | 365000 | 2010-12-07 00:00:00 |  | Developer portion
House 8 |  |  |  | SF - Large |  |  |  | 409900 | 2010-12-10 00:00:00 |  | Owner portion
House 8 |  |  |  | SF - Large |  |  |  | 409900 | 2010-12-10 00:00:00 |  | Developer portion
House 9 |  |  |  | SF - Medium |  |  |  | 307300 | 2010-12-15 00:00:00 |  | Owner portion
House 9 |  |  |  | SF - Medium |  |  |  | 307300 | 2010-12-15 00:00:00 |  | Developer portion
House 10 |  |  |  | Duplex $300K-$349K |  |  |  | 215700 | 2010-12-22 00:00:00 |  | Owner portion
House 10 |  |  |  | Duplex $300K-$349K |  |  |  | 215700 | 2010-12-22 00:00:00 |  | Developer portion
House 11 |  |  |  | Duplex $300K-$349K |  |  |  | 217400 | 2010-12-30 00:00:00 |  | Owner portion
House 11 |  |  |  | Duplex $300K-$349K |  |  |  | 217400 | 2010-12-30 00:00:00 |  | Developer portion
House 12 |  |  |  | Duplex $300K-$349K |  |  |  | 215000 | 2011-01-10 00:00:00 |  | Owner portion
House 12 |  |  |  | Duplex $300K-$349K |  |  |  | 215000 | 2011-01-10 00:00:00 |  | Developer portion
House 13 |  |  |  | Duplex $300K-$349K |  |  |  | 218200 | 2011-01-18 00:00:00 |  | Owner portion
House 13 |  |  |  | Duplex $300K-$349K |  |  |  | 218200 | 2011-01-18 00:00:00 |  | Developer portion
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | = unplatted total