Spreadsheet: 110049d1306846731-trying-to-return-value-based-on-lookup-in-table-jnrexcel
Sheet: Sheet1

 | Table 1: Paying out all Earnings
 | Company's ROE | Investor's After Corporate Tax Required Return
 |  | 0.08 | 0.09 | 0.1 | 0.11 | 0.12 | 0.13 | 0.14 |  |  | ABC Corp
 | 0.05 | 0.625 | 0.556 | 0.5 | 0.455 | 0.417 | 0.385 | 0.357
 | 0.075 | 0.938 | 0.833 | 0.75 | 0.682 | 0.625 | 0.577 | 0.536 |  |  | Equity per share: |  |  |  | Looking for value in table 1
 | 0.1 | 1.25 | 1.111 | 1 | 0.909 | 0.833 | 0.769 | 0.714 |  |  | 1.059139784946237 |  |  |  | Looking for value in table 2
 | 0.125 | 1.563 | 1.389 | 1.25 | 1.136 | 1.042 | 0.962 | 0.893
 | 0.15 | 1.875 | 1.667 | 1.5 | 1.364 | 1.25 | 1.154 | 1.071
 | 0.175 | 2.188 | 1.944 | 1.75 | 1.591 | 1.458 | 1.346 | 1.25 |  |  | ROE:
 | 0.2 | 2.5 | 2.222 | 2 | 1.818 | 1.667 | 1.538 | 1.429 |  |  | 0.51 | <- Look for this value in the row labels on the left (closest match)
 | 0.225 | 2.813 | 2.5 | 2.25 | 2.045 | 1.875 | 1.731 | 1.607
 | 0.25 | 3.125 | 2.778 | 2.5 | 2.273 | 2.083 | 1.923 | 1.786 |  |  | IRR:
 | 0.275 | 3.438 | 3.056 | 2.75 | 2.5 | 2.292 | 2.115 | 1.964 |  |  | 0.12 | <- Then look for this along the column labels
 | 0.3 | 3.75 | 3.333 | 3 | 2.727 | 2.5 | 2.308 | 2.143
 | 0.325 | 4.063 | 3.611 | 3.25 | 2.955 | 2.708 | 2.5 | 2.321 |  |  |  | Return the corresponding value in cell O7 multiplied by L8
 | 0.35 | 4.375 | 3.889 | 3.5 | 3.182 | 2.971 | 2.692 | 2.49965714285715 |  |  |  | The values in L12 & L15 will change but stay within the labels on the tables
 | 0.375 | 4.688 | 4.167 | 3.75 | 3.409 | 3.125 | 2.885 | 2.679 |  | Value from table | Value from formula
 | 0.4 | 5 | 4.444 | 4 | 3.636 | 3.333 | 3.077 | 2.85674285714286 |  |  |  | not rounded
 | 0.425 | 5.313 | 4.722 | 4.25 | 3.864 | 3.542 | 3.269 | 3.036 |  |  |  | rounded to closest number
 | 0.45 | 5.625 | 5 | 4.5 | 4.091 | 3.75 | 3.462 | 3.21382857142857
 | 0.475 | 5.938 | 5.278 | 4.75 | 4.318 | 3.958 | 3.654 | 3.393 |  |  |  | not rounded
 | 0.5 | 6.25 | 5.556 | 5 | 4.545 | 4.167 | 3.846 | 3.57091428571429 |  |  |  | rounded to closest number
 | 0.525 | 6.563 | 5.833 | 5.25 | 4.773 | 4.375 | 4.038 | 3.75
 | 0.55 | 6.875 | 6.111 | 5.5 | 5 | 4.583 | 4.231 | 3.929
 | 0.575 | 7.188 | 6.389 | 5.75 | 5.227 | 4.792 | 4.423 | 4.10654285714286
 | 0.6 | 7.5 | 6.667 | 6 | 5.455 | 5 | 4.615 | 4.286
 | Table 2: Retaining all of Earnings
 | Company's ROE | Investor's After Corporate Tax Required Return
 |  | 0.08 | 0.09 | 0.1 | 0.11 | 0.12 | 0.13 | 0.14
 | 0.05 | 0.356 | 0.274 | 0.218 | 0.176 | 0.146 | 0.122 | 0.104
 | 0.075 | 0.868 | 0.67 | 0.531 | 0.431 | 0.356 | 0.298 | 0.253
 | 0.1 | 1.494 | 1.209 | 1 | 0.811 | 0.67 | 0.561 | 0.477
 | 0.125 | 2.233 | 1.806 | 1.494 | 1.259 | 1.076 | 0.917 | 0.779
 | 0.15 | 3.1 | 2.508 | 2.075 | 1.748 | 1.494 | 1.294 | 1.132
 | 0.175 | 4.092 | 3.31 | 2.738 | 2.307 | 1.972 | 1.708 | 1.494
 | 0.2 | 5.203 | 4.209 | 3.482 | 2.933 | 2.508 | 2.171 | 1.9
 | 0.225 | 6.432 | 5.203 | 4.305 | 3.626 | 3.1 | 2.684 | 2.349
 | 0.25 | 7.776 | 6.29 | 5.203 | 4.383 | 3.748 | 3.245 | 2.84
 | 0.275 | 9.231 | 7.467 | 6.177 | 5.203 | 4.449 | 3.852 | 3.371
 | 0.3 | 10.796 | 8.733 | 7.225 | 6.086 | 5.203 | 4.505 | 3.943
 | 0.325 | 12.469 | 10.087 | 8.344 | 7.029 | 6.01 | 5.203 | 4.554
 | 0.35 | 14.248 | 11.526 | 9.535 | 8.032 | 6.867 | 5.946 | 5.203
 | 0.375 | 16.132 | 13.05 | 10.796 | 9.094 | 7.776 | 6.732 | 5.891
 | 0.4 | 18.119 | 14.658 | 12.126 | 10.214 | 8.733 | 7.562 | 6.617
 | 0.425 | 20.209 | 16.348 | 13.524 | 11.392 | 9.74 | 8.433 | 7.38
 | 0.45 | 22.399 | 18.119 | 14.989 | 12.626 | 10.796 | 9.347 | 8.18
 | 0.475 | 24.688 | 19.972 | 16.521 | 13.917 | 11.899 | 10.303 | 9.016
 | 0.5 | 27.076 | 21.903 | 18.119 | 15.263 | 13.05 | 11.299 | 9.888
 | 0.525 | 29.561 | 23.914 | 19.783 | 16.664 | 14.248 | 12.336 | 10.796
 | 0.55 | 32.143 | 26.003 | 21.511 | 18.119 | 15.493 | 13.414 | 11.739
 | 0.575 | 34.821 | 28.168 | 23.302 | 19.629 | 16.783 | 14.531 | 12.717
 | 0.6 | 37.593 | 30.411 | 25.158 | 21.192 | 18.119 | 15.688 | 13.729