Look Up Between Two Numbers

[yhasan527]

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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="colspan: 3"]Look up Table E3:G90[/TD]
[/TR]
[TR]
[TD] Starting Cost[/TD]
[TD] End Cost[/TD]
[TD]Percentage[/TD]
[/TR]
[TR]
[TD] $ 1.26[/TD]
[TD] $ 1.36[/TD]
[TD="align: right"]0.00%[/TD]
[/TR]
[TR]
[TD] $ 1.361[/TD]
[TD] $ 1.46[/TD]
[TD="align: right"]0.50%[/TD]
[/TR]
[TR]
[TD] $ 1.461[/TD]
[TD] $ 1.56[/TD]
[TD="align: right"]1.00%[/TD]
[/TR]
[TR]
[TD] $ 1.561[/TD]
[TD] $ 1.66[/TD]
[TD="align: right"]1.50%[/TD]
[/TR]
[TR]
[TD] $ 1.661[/TD]
[TD] $ 1.76[/TD]
[TD="align: right"]2.00%[/TD]
[/TR]
[TR]
[TD] $ 1.761[/TD]
[TD] $ 1.86[/TD]
[TD="align: right"]2.50%[/TD]
[/TR]
[TR]
[TD] $ 1.861[/TD]
[TD] $ 1.96[/TD]
[TD="align: right"]3.00%[/TD]
[/TR]
[TR]
[TD] $ 1.961[/TD]
[TD] $ 2.06[/TD]
[TD="align: right"]3.50%[/TD]
[/TR]
[TR]
[TD] $ 2.061[/TD]
[TD] $ 2.16[/TD]
[TD="align: right"]4.00%[/TD]
[/TR]
[TR]
[TD] $ 2.161[/TD]
[TD] $ 2.26[/TD]
[TD="align: right"]4.50%[/TD]
[/TR]
[TR]
[TD] $ 2.261[/TD]
[TD] $ 2.36[/TD]
[TD="align: right"]5.00%[/TD]
[/TR]
[TR]
[TD] $ 2.361[/TD]
[TD] $ 2.46[/TD]
[TD="align: right"]5.50%[/TD]
[/TR]
[TR]
[TD] $ 2.461[/TD]
[TD] $ 2.56[/TD]
[TD="align: right"]6.00%[/TD]
[/TR]
[TR]
[TD] $ 2.561[/TD]
[TD] $ 2.66[/TD]
[TD="align: right"]6.50%[/TD]
[/TR]
[TR]
[TD] $ 2.661[/TD]
[TD] $ 2.76[/TD]
[TD="align: right"]7.00%[/TD]
[/TR]
[TR]
[TD] $ 2.761[/TD]
[TD] $ 2.86[/TD]
[TD="align: right"]7.50%[/TD]
[/TR]
[TR]
[TD] $ 2.861[/TD]
[TD] $ 2.96[/TD]
[TD="align: right"]8.00%[/TD]
[/TR]
[TR]
[TD] $ 2.961[/TD]
[TD] $ 3.06[/TD]
[TD="align: right"]8.50%[/TD]
[/TR]
[TR]
[TD] $ 3.061[/TD]
[TD] $ 3.16[/TD]
[TD="align: right"]9.00%[/TD]
[/TR]
[TR]
[TD] $ 3.161[/TD]
[TD] $ 3.26[/TD]
[TD="align: right"]9.50%[/TD]
[/TR]
[TR]
[TD] $ 3.261[/TD]
[TD] $ 3.36[/TD]
[TD="align: right"]10.00%[/TD]
[/TR]
[TR]
[TD] $ 3.361[/TD]
[TD] $ 3.46[/TD]
[TD="align: right"]10.50%[/TD]
[/TR]
[TR]
[TD] $ 3.461[/TD]
[TD] $ 3.56[/TD]
[TD="align: right"]11.00%[/TD]
[/TR]
[TR]
[TD] $ 3.561[/TD]
[TD] $ 3.66[/TD]
[TD="align: right"]11.50%[/TD]
[/TR]
[TR]
[TD] $ 3.661[/TD]
[TD] $ 3.76[/TD]
[TD="align: right"]12.00%[/TD]
[/TR]
[TR]
[TD] $ 3.761[/TD]
[TD] $ 3.86[/TD]
[TD="align: right"]12.50%[/TD]
[/TR]
[TR]
[TD] $ 3.861[/TD]
[TD] $ 3.96[/TD]
[TD="align: right"]13.00%[/TD]
[/TR]
[TR]
[TD] $ 3.961[/TD]
[TD] $ 4.06[/TD]
[TD="align: right"]13.50%[/TD]
[/TR]
[TR]
[TD] $ 4.061[/TD]
[TD] $ 4.16[/TD]
[TD="align: right"]14.00%[/TD]
[/TR]
[TR]
[TD] $ 4.161[/TD]
[TD] $ 4.26[/TD]
[TD="align: right"]14.50%[/TD]
[/TR]
[TR]
[TD] $ 4.261[/TD]
[TD] $ 4.36[/TD]
[TD="align: right"]15.00%[/TD]
[/TR]
[TR]
[TD] $ 4.361[/TD]
[TD] $ 4.46[/TD]
[TD="align: right"]15.50%[/TD]
[/TR]
[TR]
[TD] $ 4.461[/TD]
[TD] $ 4.56[/TD]
[TD="align: right"]16.00%[/TD]
[/TR]
[TR]
[TD] $ 4.561[/TD]
[TD] $ 4.66[/TD]
[TD="align: right"]16.50%[/TD]
[/TR]
[TR]
[TD] $ 4.661[/TD]
[TD] $ 4.76[/TD]
[TD="align: right"]17.00%[/TD]
[/TR]
[TR]
[TD] $ 4.761[/TD]
[TD] $ 4.86[/TD]
[TD="align: right"]17.50%[/TD]
[/TR]
[TR]
[TD] $ 4.861[/TD]
[TD] $ 4.96[/TD]
[TD="align: right"]18.00%[/TD]
[/TR]
[TR]
[TD] $ 4.961[/TD]
[TD] $ 5.06[/TD]
[TD="align: right"]18.50%[/TD]
[/TR]
[TR]
[TD] $ 5.061[/TD]
[TD] $ 5.16[/TD]
[TD="align: right"]19.00%[/TD]
[/TR]
[TR]
[TD] $ 5.161[/TD]
[TD] $ 5.26[/TD]
[TD="align: right"]19.50%[/TD]
[/TR]
[TR]
[TD] $ 5.261[/TD]
[TD] $ 5.36[/TD]
[TD="align: right"]20.00%[/TD]
[/TR]
[TR]
[TD] $ 5.361[/TD]
[TD] $ 5.46[/TD]
[TD="align: right"]20.50%[/TD]
[/TR]
[TR]
[TD] $ 5.461[/TD]
[TD] $ 5.56[/TD]
[TD="align: right"]21.00%[/TD]
[/TR]
[TR]
[TD] $ 5.561[/TD]
[TD] $ 5.66[/TD]
[TD="align: right"]21.50%[/TD]
[/TR]
[TR]
[TD] $ 5.661[/TD]
[TD] $ 5.76[/TD]
[TD="align: right"]22.00%[/TD]
[/TR]
[TR]
[TD] $ 5.761[/TD]
[TD] $ 5.86[/TD]
[TD="align: right"]22.50%[/TD]
[/TR]
[TR]
[TD] $ 5.861[/TD]
[TD] $ 5.96[/TD]
[TD="align: right"]23.00%[/TD]
[/TR]
[TR]
[TD] $ 5.961[/TD]
[TD] $ 6.06[/TD]
[TD="align: right"]23.50%[/TD]
[/TR]
[TR]
[TD] $ 6.061[/TD]
[TD] $ 6.16[/TD]
[TD="align: right"]24.00%[/TD]
[/TR]
[TR]
[TD] $ 6.161[/TD]
[TD] $ 6.26[/TD]
[TD="align: right"]24.50%[/TD]
[/TR]
[TR]
[TD] $ 6.261[/TD]
[TD] $ 6.36[/TD]
[TD="align: right"]25.00%[/TD]
[/TR]
[TR]
[TD] $ 6.361[/TD]
[TD] $ 6.46[/TD]
[TD="align: right"]25.50%[/TD]
[/TR]
[TR]
[TD] $ 6.461[/TD]
[TD] $ 6.56[/TD]
[TD="align: right"]26.00%[/TD]
[/TR]
[TR]
[TD] $ 6.561[/TD]
[TD] $ 6.66[/TD]
[TD="align: right"]26.50%[/TD]
[/TR]
[TR]
[TD] $ 6.661[/TD]
[TD] $ 6.76[/TD]
[TD="align: right"]27.00%[/TD]
[/TR]
[TR]
[TD] $ 6.761[/TD]
[TD] $ 6.86[/TD]
[TD="align: right"]27.50%[/TD]
[/TR]
[TR]
[TD] $ 6.861[/TD]
[TD] $ 6.96[/TD]
[TD="align: right"]28.00%[/TD]
[/TR]
[TR]
[TD] $ 6.961[/TD]
[TD] $ 7.06[/TD]
[TD="align: right"]28.50%[/TD]
[/TR]
[TR]
[TD] $ 7.061[/TD]
[TD] $ 7.16[/TD]
[TD="align: right"]29.00%[/TD]
[/TR]
[TR]
[TD] $ 7.161[/TD]
[TD] $ 7.26[/TD]
[TD="align: right"]29.50%[/TD]
[/TR]
[TR]
[TD] $ 7.261[/TD]
[TD] $ 7.36[/TD]
[TD="align: right"]30.00%[/TD]
[/TR]
[TR]
[TD] $ 7.361[/TD]
[TD] $ 7.46[/TD]
[TD="align: right"]30.50%[/TD]
[/TR]
[TR]
[TD] $ 7.461[/TD]
[TD] $ 7.56[/TD]
[TD="align: right"]31.00%[/TD]
[/TR]
[TR]
[TD] $ 7.561[/TD]
[TD] $ 7.66[/TD]
[TD="align: right"]31.50%[/TD]
[/TR]
[TR]
[TD] $ 7.661[/TD]
[TD] $ 7.76[/TD]
[TD="align: right"]32.00%[/TD]
[/TR]
[TR]
[TD] $ 7.761[/TD]
[TD] $ 7.86[/TD]
[TD="align: right"]32.50%[/TD]
[/TR]
[TR]
[TD] $ 7.861[/TD]
[TD] $ 7.96[/TD]
[TD="align: right"]33.00%[/TD]
[/TR]
[TR]
[TD] $ 7.961[/TD]
[TD] $ 8.06[/TD]
[TD="align: right"]33.50%[/TD]
[/TR]
[TR]
[TD] $ 8.061[/TD]
[TD] $ 8.16[/TD]
[TD="align: right"]34.00%[/TD]
[/TR]
[TR]
[TD] $ 8.161[/TD]
[TD] $ 8.26[/TD]
[TD="align: right"]34.50%[/TD]
[/TR]
[TR]
[TD] $ 8.261[/TD]
[TD] $ 8.36[/TD]
[TD="align: right"]35.00%[/TD]
[/TR]
[TR]
[TD] $ 8.361[/TD]
[TD] $ 8.46[/TD]
[TD="align: right"]35.50%[/TD]
[/TR]
[TR]
[TD] $ 8.461[/TD]
[TD] $ 8.56[/TD]
[TD="align: right"]36.00%[/TD]
[/TR]
[TR]
[TD] $ 8.561[/TD]
[TD] $ 8.66[/TD]
[TD="align: right"]36.50%[/TD]
[/TR]
[TR]
[TD] $ 8.661[/TD]
[TD] $ 8.76[/TD]
[TD="align: right"]37.00%[/TD]
[/TR]
[TR]
[TD] $ 8.761[/TD]
[TD] $ 8.86[/TD]
[TD="align: right"]37.50%[/TD]
[/TR]
[TR]
[TD] $ 8.861[/TD]
[TD] $ 8.96[/TD]
[TD="align: right"]38.00%[/TD]
[/TR]
[TR]
[TD] $ 8.961[/TD]
[TD] $ 9.06[/TD]
[TD="align: right"]38.50%[/TD]
[/TR]
[TR]
[TD] $ 9.061[/TD]
[TD] $ 9.16[/TD]
[TD="align: right"]39.00%[/TD]
[/TR]
[TR]
[TD] $ 9.161[/TD]
[TD] $ 9.26[/TD]
[TD="align: right"]39.50%[/TD]
[/TR]
[TR]
[TD] $ 9.261[/TD]
[TD] $ 9.36[/TD]
[TD="align: right"]40.00%[/TD]
[/TR]
[TR]
[TD] $ 9.361[/TD]
[TD] $ 9.46[/TD]
[TD="align: right"]40.50%[/TD]
[/TR]
[TR]
[TD] $ 9.461[/TD]
[TD] $ 9.56[/TD]
[TD="align: right"]41.00%[/TD]
[/TR]
[TR]
[TD] $ 9.561[/TD]
[TD] $ 9.66[/TD]
[TD="align: right"]41.50%[/TD]
[/TR]
[TR]
[TD] $ 9.661[/TD]
[TD] $ 9.76[/TD]
[TD="align: right"]42.00%[/TD]
[/TR]
[TR]
[TD] $ 9.761[/TD]
[TD] $ 9.86[/TD]
[TD="align: right"]42.50%[/TD]
[/TR]
[TR]
[TD] $ 9.861[/TD]
[TD] $ 9.96[/TD]
[TD="align: right"]43.00%[/TD]
[/TR]
[TR]
[TD] $ 9.961[/TD]
[TD] $ 10.06[/TD]
[TD="align: right"]43.50%[/TD]
[/TR]
</tbody>[/TABLE]

 

[greenman]

try this:

=VLOOKUP(B2,E:G,3)

 

[yhasan527]

Wow, I'm literally red in the face for overlooking such a simple solution. this issue is part or a now 10MB file that is full of LOOKUP's, MATCH's, INDEX, and OFFSET's. I was sure that s simple VLOOKUP woulndt work.

Thank You very much

try this:

=VLOOKUP(B2,E:G,3)