Hi everyone,
I'm in need of some help. I've tried searching the boards for a resolution but do not see one that fit's my needs, so here we go. I have a look up value call it B2 ($3.789) and want to look up a table (E3:G90) that will return the percentage. I know the answer is 12.50% but cannot have a formula to find the answer. I have a rather large data set that I need to bounce off this table. I've seen similar posts but most just want to look up certain values from two columns but I need to include everything in between. If I missed a similar post please forward me to the right one, but I have found a few and they have not been able to look between the 'Starting Cost' and 'Ending Cost'. I have the file but I cannot upload the file.
I'm using Windows 7 and Office 2010
Thank You for your help
Yasir Hasan
<tbody>
</tbody>
I'm in need of some help. I've tried searching the boards for a resolution but do not see one that fit's my needs, so here we go. I have a look up value call it B2 ($3.789) and want to look up a table (E3:G90) that will return the percentage. I know the answer is 12.50% but cannot have a formula to find the answer. I have a rather large data set that I need to bounce off this table. I've seen similar posts but most just want to look up certain values from two columns but I need to include everything in between. If I missed a similar post please forward me to the right one, but I have found a few and they have not been able to look between the 'Starting Cost' and 'Ending Cost'. I have the file but I cannot upload the file.
I'm using Windows 7 and Office 2010
Thank You for your help
Yasir Hasan
Look up Table E3:G90 | ||
Starting Cost | End Cost | Percentage |
$ 1.26 | $ 1.36 | 0.00% |
$ 1.361 | $ 1.46 | 0.50% |
$ 1.461 | $ 1.56 | 1.00% |
$ 1.561 | $ 1.66 | 1.50% |
$ 1.661 | $ 1.76 | 2.00% |
$ 1.761 | $ 1.86 | 2.50% |
$ 1.861 | $ 1.96 | 3.00% |
$ 1.961 | $ 2.06 | 3.50% |
$ 2.061 | $ 2.16 | 4.00% |
$ 2.161 | $ 2.26 | 4.50% |
$ 2.261 | $ 2.36 | 5.00% |
$ 2.361 | $ 2.46 | 5.50% |
$ 2.461 | $ 2.56 | 6.00% |
$ 2.561 | $ 2.66 | 6.50% |
$ 2.661 | $ 2.76 | 7.00% |
$ 2.761 | $ 2.86 | 7.50% |
$ 2.861 | $ 2.96 | 8.00% |
$ 2.961 | $ 3.06 | 8.50% |
$ 3.061 | $ 3.16 | 9.00% |
$ 3.161 | $ 3.26 | 9.50% |
$ 3.261 | $ 3.36 | 10.00% |
$ 3.361 | $ 3.46 | 10.50% |
$ 3.461 | $ 3.56 | 11.00% |
$ 3.561 | $ 3.66 | 11.50% |
$ 3.661 | $ 3.76 | 12.00% |
$ 3.761 | $ 3.86 | 12.50% |
$ 3.861 | $ 3.96 | 13.00% |
$ 3.961 | $ 4.06 | 13.50% |
$ 4.061 | $ 4.16 | 14.00% |
$ 4.161 | $ 4.26 | 14.50% |
$ 4.261 | $ 4.36 | 15.00% |
$ 4.361 | $ 4.46 | 15.50% |
$ 4.461 | $ 4.56 | 16.00% |
$ 4.561 | $ 4.66 | 16.50% |
$ 4.661 | $ 4.76 | 17.00% |
$ 4.761 | $ 4.86 | 17.50% |
$ 4.861 | $ 4.96 | 18.00% |
$ 4.961 | $ 5.06 | 18.50% |
$ 5.061 | $ 5.16 | 19.00% |
$ 5.161 | $ 5.26 | 19.50% |
$ 5.261 | $ 5.36 | 20.00% |
$ 5.361 | $ 5.46 | 20.50% |
$ 5.461 | $ 5.56 | 21.00% |
$ 5.561 | $ 5.66 | 21.50% |
$ 5.661 | $ 5.76 | 22.00% |
$ 5.761 | $ 5.86 | 22.50% |
$ 5.861 | $ 5.96 | 23.00% |
$ 5.961 | $ 6.06 | 23.50% |
$ 6.061 | $ 6.16 | 24.00% |
$ 6.161 | $ 6.26 | 24.50% |
$ 6.261 | $ 6.36 | 25.00% |
$ 6.361 | $ 6.46 | 25.50% |
$ 6.461 | $ 6.56 | 26.00% |
$ 6.561 | $ 6.66 | 26.50% |
$ 6.661 | $ 6.76 | 27.00% |
$ 6.761 | $ 6.86 | 27.50% |
$ 6.861 | $ 6.96 | 28.00% |
$ 6.961 | $ 7.06 | 28.50% |
$ 7.061 | $ 7.16 | 29.00% |
$ 7.161 | $ 7.26 | 29.50% |
$ 7.261 | $ 7.36 | 30.00% |
$ 7.361 | $ 7.46 | 30.50% |
$ 7.461 | $ 7.56 | 31.00% |
$ 7.561 | $ 7.66 | 31.50% |
$ 7.661 | $ 7.76 | 32.00% |
$ 7.761 | $ 7.86 | 32.50% |
$ 7.861 | $ 7.96 | 33.00% |
$ 7.961 | $ 8.06 | 33.50% |
$ 8.061 | $ 8.16 | 34.00% |
$ 8.161 | $ 8.26 | 34.50% |
$ 8.261 | $ 8.36 | 35.00% |
$ 8.361 | $ 8.46 | 35.50% |
$ 8.461 | $ 8.56 | 36.00% |
$ 8.561 | $ 8.66 | 36.50% |
$ 8.661 | $ 8.76 | 37.00% |
$ 8.761 | $ 8.86 | 37.50% |
$ 8.861 | $ 8.96 | 38.00% |
$ 8.961 | $ 9.06 | 38.50% |
$ 9.061 | $ 9.16 | 39.00% |
$ 9.161 | $ 9.26 | 39.50% |
$ 9.261 | $ 9.36 | 40.00% |
$ 9.361 | $ 9.46 | 40.50% |
$ 9.461 | $ 9.56 | 41.00% |
$ 9.561 | $ 9.66 | 41.50% |
$ 9.661 | $ 9.76 | 42.00% |
$ 9.761 | $ 9.86 | 42.50% |
$ 9.861 | $ 9.96 | 43.00% |
$ 9.961 | $ 10.06 | 43.50% |
<tbody>
</tbody>