Spreadsheet: 115657d1311195506-vlookup-not-returning-correct-results-lien-book-example-
Sheet: Townhome Schedule

 | Townhomes that haven't been sold |  |  |  |  |  |  |  |  |  |  | Townhomes that sold for $175,000-$199,999 (gross assess = $575) |  |  |  |  |  |  |  |  |  |  |  | Townhomes that sold for $200,000-$224,999 (gross assess = $625) |  |  |  |  |  |  |  |  |  |  |  | Townhomes that sold for $225,000-$249,999 (gross assess = $675) |  |  |  |  |  |  |  |  |  |  |  | Townhomes that sold for $250,000-$274,999 (gross assess = $725) |  |  |  |  |  |  |  |  |  |  |  | Townhomes that sold for $275,000-$299,999 (gross assess = $825) |  |  |  |  |  |  |  |  |  |  |  | Townhomes that sold for $300,000-$349,999 (gross assess = $950) |  |  |  |  |  |  |  |  |  |  |  | Townhomes that sold for $350,000-$400,000 (gross assess = $1200)
 | Beg. Bal. | Interest | PMT | Prin. | End Bal. | 6 Mo Int | Payoff | Year |  |  |  | Beg. Bal. | Interest | PMT | Prin. | End Bal. | 6 Mo Int | Payoff | Year | Year | Developer Portion |  |  | Beg. Bal. | Interest | PMT | Prin. | End Bal. | 6 Mo Int | Payoff | Year | Year | Developer Portion |  |  | Beg. Bal. | Interest | PMT | Prin. | End Bal. | 6 Mo Int | Payoff | Year | Year | Developer Portion |  |  | Beg. Bal. | Interest | PMT | Prin. | End Bal. | 6 Mo Int | Payoff | Year | Year | Developer Portion |  |  | Beg. Bal. | Interest | PMT | Prin. | End Bal. | 6 Mo Int | Payoff | Year | Year | Developer Portion |  |  | Beg. Bal. | Interest | PMT | Prin. | End Bal. | 6 Mo Int | Payoff | Year | Year | Developer Portion |  |  | Beg. Bal. | Interest | PMT | Prin. | End Bal. | 6 Mo Int | Payoff | Year | Year | Developer Portion
2008 | 13808 |  |  |  |  |  |  | 1 | 2008 |  | 2008 | 8391 |  |  |  |  |  |  | 1 | 2008 |  |  | 2008 | 9089 |  |  |  |  |  |  | 1 | 2008 |  |  | 2008 | 9811 |  |  |  |  |  |  | 1 | 2008 |  |  | 2008 | 10534 |  |  |  |  |  |  | 1 | 2008 |  |  | 2008 | 11987 |  |  |  |  |  |  | 1 | 2008 |  |  | 2008 | 13808 |  |  |  |  |  |  | 1 | 2008 |  |  | 2008 | 17449 |  |  |  |  |  |  | 1 | 2008
2009 |  |  |  |  |  |  |  | 2 | 2009 |  | 2009 |  |  |  |  |  |  |  | 2 | 2009 |  |  | 2009 |  |  |  |  |  |  |  | 2 | 2009 |  |  | 2009 |  |  |  |  |  |  |  | 2 | 2009 |  |  | 2009 |  |  |  |  |  |  |  | 2 | 2009 |  |  | 2009 |  |  |  |  |  |  |  | 2 | 2009 |  |  | 2009 |  |  |  |  |  |  |  | 2 | 2009 |  |  | 2009 |  |  |  |  |  |  |  | 2 | 2009
2010 |  |  |  |  |  |  |  | 3 | 2010 |  | 2010 |  |  |  |  |  |  |  | 3 | 2010 |  |  | 2010 |  |  |  |  |  |  |  | 3 | 2010 |  |  | 2010 |  |  |  |  |  |  |  | 3 | 2010 |  |  | 2010 |  |  |  |  |  |  |  | 3 | 2010 |  |  | 2010 |  |  |  |  |  |  |  | 3 | 2010 |  |  | 2010 |  |  |  |  |  |  |  | 3 | 2010 |  |  | 2010 |  |  |  |  |  |  |  | 3 | 2010
2011 |  |  |  |  |  |  |  | 4 | 2011 |  | 2011 |  |  |  |  |  |  |  | 4 | 2011 |  |  | 2011 |  |  |  |  |  |  |  | 4 | 2011 |  |  | 2011 |  |  |  |  |  |  |  | 4 | 2011 |  |  | 2011 |  |  |  |  |  |  |  | 4 | 2011 |  |  | 2011 |  |  |  |  |  |  |  | 4 | 2011 |  |  | 2011 |  |  |  |  |  |  |  | 4 | 2011 |  |  | 2011 |  |  |  |  |  |  |  | 4 | 2011
2012 |  |  |  |  |  |  |  | 5 | 2012 |  | 2012 |  |  |  |  |  |  |  | 5 | 2012 |  |  | 2012 |  |  |  |  |  |  |  | 5 | 2012 |  |  | 2012 |  |  |  |  |  |  |  | 5 | 2012 |  |  | 2012 |  |  |  |  |  |  |  | 5 | 2012 |  |  | 2012 |  |  |  |  |  |  |  | 5 | 2012 |  |  | 2012 |  |  |  |  |  |  |  | 5 | 2012 |  |  | 2012 |  |  |  |  |  |  |  | 5 | 2012
2013 |  |  |  |  |  |  |  | 6 | 2013 |  | 2013 |  |  |  |  |  |  |  | 6 | 2013 |  |  | 2013 |  |  |  |  |  |  |  | 6 | 2013 |  |  | 2013 |  |  |  |  |  |  |  | 6 | 2013 |  |  | 2013 |  |  |  |  |  |  |  | 6 | 2013 |  |  | 2013 |  |  |  |  |  |  |  | 6 | 2013 |  |  | 2013 |  |  |  |  |  |  |  | 6 | 2013 |  |  | 2013 |  |  |  |  |  |  |  | 6 | 2013
2014 |  |  |  |  |  |  |  | 7 | 2014 |  | 2014 |  |  |  |  |  |  |  | 7 | 2014 |  |  | 2014 |  |  |  |  |  |  |  | 7 | 2014 |  |  | 2014 |  |  |  |  |  |  |  | 7 | 2014 |  |  | 2014 |  |  |  |  |  |  |  | 7 | 2014 |  |  | 2014 |  |  |  |  |  |  |  | 7 | 2014 |  |  | 2014 |  |  |  |  |  |  |  | 7 | 2014 |  |  | 2014 |  |  |  |  |  |  |  | 7 | 2014
2015 |  |  |  |  |  |  |  | 8 | 2015 |  | 2015 |  |  |  |  |  |  |  | 8 | 2015 |  |  | 2015 |  |  |  |  |  |  |  | 8 | 2015 |  |  | 2015 |  |  |  |  |  |  |  | 8 | 2015 |  |  | 2015 |  |  |  |  |  |  |  | 8 | 2015 |  |  | 2015 |  |  |  |  |  |  |  | 8 | 2015 |  |  | 2015 |  |  |  |  |  |  |  | 8 | 2015 |  |  | 2015 |  |  |  |  |  |  |  | 8 | 2015
2016 |  |  |  |  |  |  |  | 9 | 2016 |  | 2016 |  |  |  |  |  |  |  | 9 | 2016 |  |  | 2016 |  |  |  |  |  |  |  | 9 | 2016 |  |  | 2016 |  |  |  |  |  |  |  | 9 | 2016 |  |  | 2016 |  |  |  |  |  |  |  | 9 | 2016 |  |  | 2016 |  |  |  |  |  |  |  | 9 | 2016 |  |  | 2016 |  |  |  |  |  |  |  | 9 | 2016 |  |  | 2016 |  |  |  |  |  |  |  | 9 | 2016
2017 |  |  |  |  |  |  |  | 10 | 2017 |  | 2017 |  |  |  |  |  |  |  | 10 | 2017 |  |  | 2017 |  |  |  |  |  |  |  | 10 | 2017 |  |  | 2017 |  |  |  |  |  |  |  | 10 | 2017 |  |  | 2017 |  |  |  |  |  |  |  | 10 | 2017 |  |  | 2017 |  |  |  |  |  |  |  | 10 | 2017 |  |  | 2017 |  |  |  |  |  |  |  | 10 | 2017 |  |  | 2017 |  |  |  |  |  |  |  | 10 | 2017
2018 |  |  |  |  |  |  |  | 11 | 2018 |  | 2018 |  |  |  |  |  |  |  | 11 | 2018 |  |  | 2018 |  |  |  |  |  |  |  | 11 | 2018 |  |  | 2018 |  |  |  |  |  |  |  | 11 | 2018 |  |  | 2018 |  |  |  |  |  |  |  | 11 | 2018 |  |  | 2018 |  |  |  |  |  |  |  | 11 | 2018 |  |  | 2018 |  |  |  |  |  |  |  | 11 | 2018 |  |  | 2018 |  |  |  |  |  |  |  | 11 | 2018
2019 |  |  |  |  |  |  |  | 12 | 2019 |  | 2019 |  |  |  |  |  |  |  | 12 | 2019 |  |  | 2019 |  |  |  |  |  |  |  | 12 | 2019 |  |  | 2019 |  |  |  |  |  |  |  | 12 | 2019 |  |  | 2019 |  |  |  |  |  |  |  | 12 | 2019 |  |  | 2019 |  |  |  |  |  |  |  | 12 | 2019 |  |  | 2019 |  |  |  |  |  |  |  | 12 | 2019 |  |  | 2019 |  |  |  |  |  |  |  | 12 | 2019
2020 |  |  |  |  |  |  |  | 13 | 2020 |  | 2020 |  |  |  |  |  |  |  | 13 | 2020 |  |  | 2020 |  |  |  |  |  |  |  | 13 | 2020 |  |  | 2020 |  |  |  |  |  |  |  | 13 | 2020 |  |  | 2020 |  |  |  |  |  |  |  | 13 | 2020 |  |  | 2020 |  |  |  |  |  |  |  | 13 | 2020 |  |  | 2020 |  |  |  |  |  |  |  | 13 | 2020 |  |  | 2020 |  |  |  |  |  |  |  | 13 | 2020
2021 |  |  |  |  |  |  |  | 14 | 2021 |  | 2021 |  |  |  |  |  |  |  | 14 | 2021 |  |  | 2021 |  |  |  |  |  |  |  | 14 | 2021 |  |  | 2021 |  |  |  |  |  |  |  | 14 | 2021 |  |  | 2021 |  |  |  |  |  |  |  | 14 | 2021 |  |  | 2021 |  |  |  |  |  |  |  | 14 | 2021 |  |  | 2021 |  |  |  |  |  |  |  | 14 | 2021 |  |  | 2021 |  |  |  |  |  |  |  | 14 | 2021
2022 |  |  |  |  |  |  |  | 15 | 2022 |  | 2022 |  |  |  |  |  |  |  | 15 | 2022 |  |  | 2022 |  |  |  |  |  |  |  | 15 | 2022 |  |  | 2022 |  |  |  |  |  |  |  | 15 | 2022 |  |  | 2022 |  |  |  |  |  |  |  | 15 | 2022 |  |  | 2022 |  |  |  |  |  |  |  | 15 | 2022 |  |  | 2022 |  |  |  |  |  |  |  | 15 | 2022 |  |  | 2022 |  |  |  |  |  |  |  | 15 | 2022
2023 |  |  |  |  |  |  |  | 16 | 2023 |  | 2023 |  |  |  |  |  |  |  | 16 | 2023 |  |  | 2023 |  |  |  |  |  |  |  | 16 | 2023 |  |  | 2023 |  |  |  |  |  |  |  | 16 | 2023 |  |  | 2023 |  |  |  |  |  |  |  | 16 | 2023 |  |  | 2023 |  |  |  |  |  |  |  | 16 | 2023 |  |  | 2023 |  |  |  |  |  |  |  | 16 | 2023 |  |  | 2023 |  |  |  |  |  |  |  | 16 | 2023
2024 |  |  |  |  |  |  |  | 17 | 2024 |  | 2024 |  |  |  |  |  |  |  | 17 | 2024 |  |  | 2024 |  |  |  |  |  |  |  | 17 | 2024 |  |  | 2024 |  |  |  |  |  |  |  | 17 | 2024 |  |  | 2024 |  |  |  |  |  |  |  | 17 | 2024 |  |  | 2024 |  |  |  |  |  |  |  | 17 | 2024 |  |  | 2024 |  |  |  |  |  |  |  | 17 | 2024 |  |  | 2024 |  |  |  |  |  |  |  | 17 | 2024
2025 |  |  |  |  |  |  |  | 18 | 2025 |  | 2025 |  |  |  |  |  |  |  | 18 | 2025 |  |  | 2025 |  |  |  |  |  |  |  | 18 | 2025 |  |  | 2025 |  |  |  |  |  |  |  | 18 | 2025 |  |  | 2025 |  |  |  |  |  |  |  | 18 | 2025 |  |  | 2025 |  |  |  |  |  |  |  | 18 | 2025 |  |  | 2025 |  |  |  |  |  |  |  | 18 | 2025 |  |  | 2025 |  |  |  |  |  |  |  | 18 | 2025
2026 |  |  |  |  |  |  |  | 19 | 2026 |  | 2026 |  |  |  |  |  |  |  | 19 | 2026 |  |  | 2026 |  |  |  |  |  |  |  | 19 | 2026 |  |  | 2026 |  |  |  |  |  |  |  | 19 | 2026 |  |  | 2026 |  |  |  |  |  |  |  | 19 | 2026 |  |  | 2026 |  |  |  |  |  |  |  | 19 | 2026 |  |  | 2026 |  |  |  |  |  |  |  | 19 | 2026 |  |  | 2026 |  |  |  |  |  |  |  | 19 | 2026
2027 |  |  |  |  |  |  |  | 20 | 2027 |  | 2027 |  |  |  |  |  |  |  | 20 | 2027 |  |  | 2027 |  |  |  |  |  |  |  | 20 | 2027 |  |  | 2027 |  |  |  |  |  |  |  | 20 | 2027 |  |  | 2027 |  |  |  |  |  |  |  | 20 | 2027 |  |  | 2027 |  |  |  |  |  |  |  | 20 | 2027 |  |  | 2027 |  |  |  |  |  |  |  | 20 | 2027 |  |  | 2027 |  |  |  |  |  |  |  | 20 | 2027
2028 |  |  |  |  |  |  |  | 21 | 2028 |  | 2028 |  |  |  |  |  |  |  | 21 | 2028 |  |  | 2028 |  |  |  |  |  |  |  | 21 | 2028 |  |  | 2028 |  |  |  |  |  |  |  | 21 | 2028 |  |  | 2028 |  |  |  |  |  |  |  | 21 | 2028 |  |  | 2028 |  |  |  |  |  |  |  | 21 | 2028 |  |  | 2028 |  |  |  |  |  |  |  | 21 | 2028 |  |  | 2028 |  |  |  |  |  |  |  | 21 | 2028
2029 |  |  |  |  |  |  |  | 22 | 2029 |  | 2029 |  |  |  |  |  |  |  | 22 | 2029 |  |  | 2029 |  |  |  |  |  |  |  | 22 | 2029 |  |  | 2029 |  |  |  |  |  |  |  | 22 | 2029 |  |  | 2029 |  |  |  |  |  |  |  | 22 | 2029 |  |  | 2029 |  |  |  |  |  |  |  | 22 | 2029 |  |  | 2029 |  |  |  |  |  |  |  | 22 | 2029 |  |  | 2029 |  |  |  |  |  |  |  | 22 | 2029
2030 |  |  |  |  |  |  |  | 23 | 2030 |  | 2030 |  |  |  |  |  |  |  | 23 | 2030 |  |  | 2030 |  |  |  |  |  |  |  | 23 | 2030 |  |  | 2030 |  |  |  |  |  |  |  | 23 | 2030 |  |  | 2030 |  |  |  |  |  |  |  | 23 | 2030 |  |  | 2030 |  |  |  |  |  |  |  | 23 | 2030 |  |  | 2030 |  |  |  |  |  |  |  | 23 | 2030 |  |  | 2030 |  |  |  |  |  |  |  | 23 | 2030
2031 |  |  |  |  |  |  |  | 24 | 2031 |  | 2031 |  |  |  |  |  |  |  | 24 | 2031 |  |  | 2031 |  |  |  |  |  |  |  | 24 | 2031 |  |  | 2031 |  |  |  |  |  |  |  | 24 | 2031 |  |  | 2031 |  |  |  |  |  |  |  | 24 | 2031 |  |  | 2031 |  |  |  |  |  |  |  | 24 | 2031 |  |  | 2031 |  |  |  |  |  |  |  | 24 | 2031 |  |  | 2031 |  |  |  |  |  |  |  | 24 | 2031
2032 |  |  |  |  |  |  |  | 25 | 2032 |  | 2032 |  |  |  |  |  |  |  | 25 | 2032 |  |  | 2032 |  |  |  |  |  |  |  | 25 | 2032 |  |  | 2032 |  |  |  |  |  |  |  | 25 | 2032 |  |  | 2032 |  |  |  |  |  |  |  | 25 | 2032 |  |  | 2032 |  |  |  |  |  |  |  | 25 | 2032 |  |  | 2032 |  |  |  |  |  |  |  | 25 | 2032 |  |  | 2032 |  |  |  |  |  |  |  | 25 | 2032
2033 |  |  |  |  |  |  |  | 26 | 2033 |  | 2033 |  |  |  |  |  |  |  | 26 | 2033 |  |  | 2033 |  |  |  |  |  |  |  | 26 | 2033 |  |  | 2033 |  |  |  |  |  |  |  | 26 | 2033 |  |  | 2033 |  |  |  |  |  |  |  | 26 | 2033 |  |  | 2033 |  |  |  |  |  |  |  | 26 | 2033 |  |  | 2033 |  |  |  |  |  |  |  | 26 | 2033 |  |  | 2033 |  |  |  |  |  |  |  | 26 | 2033
2034 |  |  |  |  |  |  |  | 27 | 2034 |  | 2034 |  |  |  |  |  |  |  | 27 | 2034 |  |  | 2034 |  |  |  |  |  |  |  | 27 | 2034 |  |  | 2034 |  |  |  |  |  |  |  | 27 | 2034 |  |  | 2034 |  |  |  |  |  |  |  | 27 | 2034 |  |  | 2034 |  |  |  |  |  |  |  | 27 | 2034 |  |  | 2034 |  |  |  |  |  |  |  | 27 | 2034 |  |  | 2034 |  |  |  |  |  |  |  | 27 | 2034
2035 |  |  |  |  |  |  |  | 28 | 2035 |  | 2035 |  |  |  |  |  |  |  | 28 | 2035 |  |  | 2035 |  |  |  |  |  |  |  | 28 | 2035 |  |  | 2035 |  |  |  |  |  |  |  | 28 | 2035 |  |  | 2035 |  |  |  |  |  |  |  | 28 | 2035 |  |  | 2035 |  |  |  |  |  |  |  | 28 | 2035 |  |  | 2035 |  |  |  |  |  |  |  | 28 | 2035 |  |  | 2035 |  |  |  |  |  |  |  | 28 | 2035
2036 |  |  |  |  |  |  |  | 29 | 2036 |  | 2036 |  |  |  |  |  |  |  | 29 | 2036 |  |  | 2036 |  |  |  |  |  |  |  | 29 | 2036 |  |  | 2036 |  |  |  |  |  |  |  | 29 | 2036 |  |  | 2036 |  |  |  |  |  |  |  | 29 | 2036 |  |  | 2036 |  |  |  |  |  |  |  | 29 | 2036 |  |  | 2036 |  |  |  |  |  |  |  | 29 | 2036 |  |  | 2036 |  |  |  |  |  |  |  | 29 | 2036
2037 |  |  |  |  |  |  |  | 30 | 2037 |  | 2037 |  |  |  |  |  |  |  | 30 | 2037 |  |  | 2037 |  |  |  |  |  |  |  | 30 | 2037 |  |  | 2037 |  |  |  |  |  |  |  | 30 | 2037 |  |  | 2037 |  |  |  |  |  |  |  | 30 | 2037 |  |  | 2037 |  |  |  |  |  |  |  | 30 | 2037 |  |  | 2037 |  |  |  |  |  |  |  | 30 | 2037 |  |  | 2037 |  |  |  |  |  |  |  | 30 | 2037