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.
Regards,
Ravi
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 working exclusively on Excel based projects, I work on such Excel based tasks every single day.
I have 20 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 200 HOURS on automation in Excel every month.
Have a Great Day!
Srinivasan Krishnamoorthi
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 will do my work efficiently and i am sure you will love my work. I will do my work this much nicely so that you will hire every work to me and this is my challange .If you are reslly a good person and kind hearted then after reading this i am sure you will hire me for your work . and one ;ast thing i want to say that i am best for this work . I hope a better future for you , your family and your relatives.
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 you.
Once you contact me I can begin work immediately.
Thank you
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 different weight ranges.
I can provide you with the sample excel and formula in next 4 hours once you select me.
Let me know. I have a query which I will confirm once you select me
Thanks and Regards