Hi,
I have two separate tabs on one file.
1. Weight
2. rates
I have below matching columns on them.
Carrier
Weight
Density
Rate
Type
Origin City
Origin Prov
Destination City
Destination Prov
On "Weights" tab, based on those matching field, I need to know the matching rate between those FROM & TO city from "RATES" sheet based on the matching weight.
For all the shipments on "weight" sheet, I have individual weight of those shipments.
Where as in "rates" sheet, I have rate for specific weight brackets.
WEIGHT BREAK
0-499 500 -999 1000-1999 2000-4999 5000-9999 10000-19999 20000-29999 >30000
So, any load that has weight between 0 & 499 they have same rate and for shipments weighing between 500 to 999 lbs the weight rate is same & so.
Can you please help me to get one formula which I can use in Column "K" , "Freight Rate" based on rates from sheet "rates"
Thanks a lot in advance for your help with same.
Kindly find the file attached herewith for reference.
-Ravi
Bookmarks