Spreadsheet: 880511d1728310755-xlookup-error-dynamic-formula
Sheet: Sheet1

 |  |  | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | 2042 | 2043 | 2044
 |  |  | 0 | 0 | 0 | 0 | 0 | 3142.857142857143 | 3081.232492997199 | 3020.816169605097 | 2961.584480004997 | 2903.51419608333 | 2846.582545179735 | 2790.767201156603 | 2736.046275643729 | 2682.398309454636 | 2629.802264171212 | 2578.237513893345 | 2527.683837150338 | 2478.12140897092 | 2429.530793108745 | 2381.892934420338 | 2335.189151392488
10 |  | 1.67
 |  | 3.5
 |  |  |  | ORIGINAL IDEA
 |  |  | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | 2042 | 2043 | 2044
 |  |  | 0 | 0 | 0 | 0 | 0 | 3142.857142857143 | 3081.232492997199 | 3020.816169605097 | 2961.584480004997 | 2903.51419608333 | 2846.582545179735 | 2790.767201156603 | 2736.046275643729 | 2682.398309454636 | 2629.802264171212 | 2578.237513893345 | 2527.683837150338 | 2478.12140897092 | 2429.530793108745 | 2381.892934420338 | 2335.189151392488
 |  |  |  | WHAT IT SHOULD LOOK LIKE
 |  |  | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | 2042 | 2043 | 2044
 |  |  | 0 | 0 | 0 | 0 | 0 | 3142.857142857143 | 3081.232492997199 | 3020.816169605097 | 2961.584480004997 | 2903.51419608333 | 2846.582545179735 | 2790.767201156603 | 2736.046275643729 | 2682.398309454636 | 2629.802264171212 | 2578.237513893345 | 2527.683837150338 | 2478.12140897092 | 2429.530793108745 | 2381.892934420338 | 2335.189151392488
 |  |  |  |  |  |  |  | 62982.85714285714 | 61747.89915966385 | 60537.15603888614 | 59350.15297930013 | 58186.42448950994 | 57045.51420540189 | 55926.97471117832 | 54830.36736390032 | 53755.26212147091 | 52701.23737399108 | 108285.9755835205 | 106162.7211603142 | 104081.0991767786 | 102040.2933105673 | 100039.5032456542 | 98077.9443584845
 |  |  |  |  |  |  |  |  | 61747.89915966385 | 60537.15603888614 | 59350.15297930013 | 58186.42448950994 | 57045.51420540189 | 55926.97471117832 | 54830.36736390032 | 53755.26212147091 | 52701.23737399108 | 108285.9755835205 | 106162.7211603142 | 104081.0991767786 | 102040.2933105673 | 100039.5032456542 | 98077.9443584845
 |  |  |  |  |  |  |  |  |  | 60537.15603888614 | 59350.15297930013 | 58186.42448950994 | 57045.51420540189 | 55926.97471117832 | 54830.36736390032 | 53755.26212147091 | 52701.23737399108 | 108285.9755835205 | 106162.7211603142 | 104081.0991767786 | 102040.2933105673 | 100039.5032456542 | 98077.9443584845
 |  |  |  |  |  |  |  |  |  |  | 59350.15297930013 | 58186.42448950994 | 57045.51420540189 | 55926.97471117832 | 54830.36736390032 | 53755.26212147091 | 52701.23737399108 | 108285.9755835205 | 106162.7211603142 | 104081.0991767786 | 102040.2933105673 | 100039.5032456542 | 98077.9443584845
 |  |  |  |  |  |  |  |  |  |  |  | 58186.42448950994 | 57045.51420540189 | 55926.97471117832 | 54830.36736390032 | 53755.26212147091 | 52701.23737399108 | 108285.9755835205 | 106162.7211603142 | 104081.0991767786 | 102040.2933105673 | 100039.5032456542 | 98077.9443584845
 |  |  |  |  |  |  |  |  |  |  |  |  | 57045.51420540189 | 55926.97471117832 | 54830.36736390032 | 53755.26212147091 | 52701.23737399108 | 108285.9755835205 | 106162.7211603142 | 104081.0991767786 | 102040.2933105673 | 100039.5032456542 | 98077.9443584845
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 55926.97471117832 | 54830.36736390032 | 53755.26212147091 | 52701.23737399108 | 108285.9755835205 | 106162.7211603142 | 104081.0991767786 | 102040.2933105673 | 100039.5032456542 | 98077.9443584845
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54830.36736390032 | 53755.26212147091 | 52701.23737399108 | 108285.9755835205 | 106162.7211603142 | 104081.0991767786 | 102040.2933105673 | 100039.5032456542 | 98077.9443584845
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53755.26212147091 | 52701.23737399108 | 108285.9755835205 | 106162.7211603142 | 104081.0991767786 | 102040.2933105673 | 100039.5032456542 | 98077.9443584845
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52701.23737399108 | 108285.9755835205 | 106162.7211603142 | 104081.0991767786 | 102040.2933105673 | 100039.5032456542 | 98077.9443584845
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 108285.9755835205 | 106162.7211603142 | 104081.0991767786 | 102040.2933105673 | 100039.5032456542 | 98077.9443584845
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 106162.7211603142 | 104081.0991767786 | 102040.2933105673 | 100039.5032456542 | 98077.9443584845
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 104081.0991767786 | 102040.2933105673 | 100039.5032456542 | 98077.9443584845
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 102040.2933105673 | 100039.5032456542 | 98077.9443584845
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100039.5032456542 | 98077.9443584845
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 98077.9443584845