I like to get rate value for city based on different rate brackets from another sheet.
Example : Rate for Sudbury from Brampton if the weight is between 500-1000 lbs and rate if the weight is between 1000-2000 and so on ,I have file ready with me.
In cell Q2 (CTT Rate) I need rate for Sudbury (J2) from rate sheet "CTT 6 LBS Rate, for the order weighing 517.00 lbs.
Currently under CTT 6 LBS Rates file has 8 different rates as per the weight brackets.
As the order has the actual weight of 517 lbs, I want system to do V lookup and choose rate from J column (500-1000) for Sudbury as 28.42
I am able to run the scenario with simple VLOOKUP but currently I have to bifurcate the file in 8 different sheets as per its weight bracket.
I need your help to get all the calculation done on 1 sheet only.
Your help is really appreciated.