Need some help, I need a formula that will index/match the costs for the state and weight brackets in the table.
If I enter CA (B8) and 2000 (B9) for the weight the formula should choose "$.16" in B10.
Since the weight brackets are a range I could not figure the formula to work with it. I could add a row for the weights if needed to create a range if that makes sense.
Thank you
<tbody>
</tbody>
If I enter CA (B8) and 2000 (B9) for the weight the formula should choose "$.16" in B10.
Since the weight brackets are a range I could not figure the formula to work with it. I could add a row for the weights if needed to create a range if that makes sense.
Thank you
A | B | C | D | E | F | G | H | |
State | 1-499 | 500-999 | 1000-1999 | 2000-4999 | 5000-9999 | 10000-19999 | 20000+ | |
1 | AL | $ 1.02 | $ 0.50 | $ 0.40 | $ 0.34 | $ 0.30 | $ 0.26 | $ 0.23 |
2 | AR | $ 0.88 | $ 0.52 | $ 0.41 | $ 0.33 | $ 0.27 | $ 0.22 | $ 0.19 |
3 | AZ | $ 0.68 | $ 0.32 | $ 0.29 | $ 0.23 | $ 0.16 | $ 0.13 | $ 0.11 |
4 | CA | $ 0.48 | $ 0.20 | $ 0.20 | $ 0.16 | $ 0.10 | $ 0.07 | $ 0.05 |
5 | CO | $ 0.80 | $ 0.41 | $ 0.36 | $ 0.29 | $ 0.22 | $ 0.19 | $ 0.16 |
6 | CT | $ 1.06 | $ 0.62 | $ 0.49 | $ 0.39 | $ 0.31 | $ 0.28 | $ 0.25 |
7 | ||||||||
8 | State | CA | ||||||
9 | Weight | 2,000 | ||||||
10 | result | $ 0.16 |
<tbody>
</tbody>