I'm trying to look up rates based off of weight and miles.
<tbody>
</tbody>
I have a cell where I type in the weight and another cell where I type in the miles. I want the 3rd table to be the rate
<tbody>
</tbody>
I know the answer should be 4.5, but not sure how to look it up. Do I use vlookup, hlookup, INDEX, or a combination?
Thanks!
Weight | ||||
Miles | 500 | 1000 | 1500 | 2000 |
250 | 4.5 | 6.5 | 8.5 | 10.5 |
500 | 7.5 | 9.5 | 11.5 | 13.5 |
750 | 12.5 | 14.5 | 16.5 | 18.5 |
<tbody>
</tbody>
I have a cell where I type in the weight and another cell where I type in the miles. I want the 3rd table to be the rate
Weight | 675 |
Miles | 300 |
Rate | XX |
<tbody>
</tbody>
I know the answer should be 4.5, but not sure how to look it up. Do I use vlookup, hlookup, INDEX, or a combination?
Thanks!