I need help on constructing a look up. In my spread sheet I will plug in the service type, zone and weight in three different cells. I need it to go to a table that called rates and find the rate based on the info found in the table. example of the table below.
<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>
Service | Lbs. | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 6 | Zone 7 | Zone 8 |
UPS GND RESI | 1.00 | 10.63 | 10.63 | 10.63 | 10.63 | 10.63 | 10.63 | 10.63 |
UPS GND RESI | 2.00 | 10.63 | 10.63 | 10.63 | 10.63 | 10.63 | 10.83 | 10.99 |
UPS GND RESI | 3.00 | 10.63 | 10.63 | 10.63 | 10.76 | 11.09 | 11.38 | 11.81 |
UPS GND RESI | 4.00 | 10.63 | 10.63 | 10.90 | 11.27 | 11.52 | 12.04 | 12.56 |
UPS GND RESI | 5.00 | 10.63 | 10.63 | 11.14 | 11.62 | 11.92 | 12.41 | 13.07 |
<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>