Multiple Rates as per Weight brackets

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.



Skills: Excel, Data Processing, Visual Basic, Mathematics

See more: oscommerce multiple product weight, magento table rates weight, magento table rates weight csv file, zencart tutorial table rates weight, zen cart zone rates weight module, chefs on the run rates, multiple customer types with different tarriff rates on xcell, run regedit as system, run cmd as system windows 10, windows run something as system, run program as system, jenkins run powershell as administrator, run confluence as a service, apache run command as root, how to run game as administrator in steam, magento table rates weight vs destination, run openvpn as a service, run command as root without sudo, magento shipping table rates weight vs destination, corporate triple a bond interest rates for 12 consecutive months are as follows:

About the Employer:
( 0 reviews ) Mississauga, Canada

Project ID: #21681920

Awarded to:


SOLUTION READY! Hi Ravi! It is straightforward - I have looked at the table and already set up formulas for automatically retrieving prices based on consignee city and weight bracket. Being a full time freelancer wo More

$10 CAD in 1 day
(191 Reviews)

6 freelancers are bidding on average $25 for this job


I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$50 CAD in 1 day
(120 Reviews)

$ 15 CAD Only ---- In just 6 Hours ----- Data Entry, Web Scrapping, Excel VBA Macro Coding and Formula Generation Expert

$15 CAD in 1 day
(28 Reviews)

I myself is enough for proofing that no one can do this project better than me. I think there is no proof required to say that I am a best candidate for this project. I will not give you any chance for complain and wil More

$20 CAD in 5 days
(0 Reviews)

Dear Sir, I am an experienced data analyst who has built reporting dashboards as per many project requirements. I am sure that my excel and vba expert level skills will permit me create the right solution sheet for y More

$25 CAD in 1 day
(0 Reviews)

Hi, I have gone through your excel and images attached in the query I have already worked upon it and I am ready with the sample sheet and final formula, wherein you can use single sheet instead of 8 sheets for diffe More

$30 CAD in 1 day
(0 Reviews)