On one sheet I have the item 2shells and the cost 0.75, I need the ability to look at another sheet with multiple tables each table constist of a low cost, high cost and then a percentage. I need to look up the cost between those values and return the coresponding percentage. I was able to do this with an lengthy if statement but that just didn't meet my needs and ran out of options. The pricing groups has not been finished just created to give a general idea, that information can be rearrange to what ever format. Any help would be greatly appreciated.
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col></colgroup>
2shells | 2.5shells | |||||||
Low Cost | High Cost | Shells2 | Low Cost | High Cost | Shells2 | |||
1 | $0.00 | $25.00 | 300% | 1 | $0.00 | $25.00 | 300% | |
2 | $25.01 | $50.00 | 400% | 2 | $25.01 | $50.00 | 400% | |
3 | $50.01 | $75.00 | 500% | 3 | $50.01 | $75.00 | 500% | |
4 | $75.01 | $100.00 | 600% | 4 | $75.01 | $100.00 | 600% | |
5 | $100.01 | $125.00 | 700% | 5 | $100.01 | $125.00 | 700% | |
6 | $125.01 | $150.00 | 800% | 6 | $125.01 | $150.00 | 800% | |
7 | $150.01 | $99,999.99 | 900% | 7 | $150.01 | $99,999.99 | 900% | |
6shells | 8shells | |||||||
Low Cost | High Cost | Shells2 | Low Cost | High Cost | Shells2 | |||
1 | $0.00 | $25.00 | 300% | 1 | $0.00 | $25.00 | 300% | |
2 | $25.01 | $50.00 | 400% | 2 | $25.01 | $50.00 | 400% | |
3 | $50.01 | $75.00 | 500% | 3 | $50.01 | $75.00 | 500% | |
4 | $75.01 | $100.00 | 600% | 4 | $75.01 | $100.00 | 600% | |
5 | $100.01 | $125.00 | 700% | 5 | $100.01 | $125.00 | 700% | |
6 | $125.01 | $150.00 | 800% | 6 | $125.01 | $150.00 | 800% | |
7 | $150.01 | $99,999.99 | 900% | 7 | $150.01 | $99,999.99 | 900% |
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col></colgroup>