I have a workbook that has three sheets. I need to accomplish 2 things,
1. In the summary sheet, I need to use an index or sumproduct to look up matching set of origin & destination zips and return zone. (zip sheet column C).
The origin and destination zips get entered on Summary sheet in 5 digit.
However, the lookup is for only RIGHT (3) numbers.
I have been usuccessfully using the following formula, but at least you can see what I am going for.
2. Depending on the code in B4, I would like to show the data from RATE sheet beginning in cell B7. If I can it to work for the following, I can adjust for additional codes.
if B4 = PO show Rate!A32 in Summary sheet starting B7.
It can show everything below Rate!A32