Need to get Rates based on INDEX+MATCH or CSE or VLOOKUP Formula
$10-30 CAD
Closed
Posted almost 3 years ago
$10-30 CAD
Paid on delivery
I have shipment data on one sheet and Rate data on next sheet.
On "Data" Sheet, I need "Audited Rate" in Column Y, based on following matches
1. Column J - "Shipper City"
2. Column P - "Consignee City"
3. Column V - "Billed Wgt"
3a - We need to match Shipper City (Column J)+ Consignee City (Column P) & have to calculate "Audited Rate" (Column Y)based on "Billed Weight" (Column V)of individual shipment.
3b - We have weight brackets in next sheet "Rates"
Based on given weight, we have to find appropriate rate from weight bracket from "Rates" sheet.
Weight Brackets are as follow on "Rates" Sheet.
Weight Brackets MIN Value
1 - 499 LBS 0
500 - 999 LBS 500
1,000 - 1,999 LBS 1000
2,000 - 4,999 LBS 2000
5,000 - 9,999 LBS 5000
10,000 - 19,999 LBS 10000
20,000 + LBS 20000
MINIMUM CHARGE
I need "MIN Charge" in Column Z : Based on below matches
1. Column J - "Shipper City"
2. Column P - "Consignee City"
Match both "Shipper City" & "Consignee City" and based on it find the FROM "Rates" sheet under "MINIMUM Charge" Value (Column N)
EXAMPLE
Shipper City Consignee City Min Charge
BURNABY CALGARY 38.68
Will you please help me to get the "Audited Rate" based on INDEX+MATCH or any kind of VLOOKUP Formula.
Thanks a lot in advance for all your help.
Hi, this is very simple, INDEX+MATCH formula should be perfect case for this one. If you are interested feel free to message me and i will help you in matter of minutes.
Thanks, Milan
"Sir,
I can fix this issue via vlookup within hour.
I am Excel and All Excel formulas Advance Level Expert. This is a basic work for me. i can complete this project with in Few hours with added quality.
About me
I am Chartered Accountant with more than 4 years of experience from worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expects 100% accuracy from me. I am Microsoft Excel, accounting, auditing, Financial statements, Form Creation in Excel through VBA and in Google Sheet and QuickBooks expert. It is my second month here and i have 60 5 stars reviews here here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, excel, QuickBooks and auditing related work with quality, efficiency and on reduced rates.
Note. The price is negotiable.
I will be available for any query round the clock even if the project is completed.
Regards
Arman Kakar"
Greetings!
I’m very much interested to your requirements and Job openings. I am a Professional in Microsoft office, Data Entry, PDF, and excel with over 5 years of experience, therefore, I can easily do this job. You can message me to discuss the detail.
Why me?
My goal is to offer services to you that are profitable. I don’t want you to place an order once and that’s it. For me to be successful, I need you to come back and order again. Give me the opportunity to work on your project. I wish to build a long-term relationship with you. We can have further discussion in chat. Thanks!
Warm Regards,
Mohamed A.
Hi, I have created formulas that gets the "MIN Charge" in Column Z based on "Shipper City" and "Consignee City".
Further, I have spotted an error in formula created in Column Y "Audited Rate" resulting in incorrect results.
I have done it by two different methods, 100% accurate and cross-checked.
You can initiate the chat if still interested.
Thanks,
Hamid
Hi,
I’m from Vietnam with a lot of experience in Excel & Excel formula. I can give you the simple Excel formula that calculates Min charge according to your requirements.
Would be great to hear from you
Duong
Hi, Greetings! ✅checked your project details.
I can build excel INDEX+MATCH,VLOOKUP Formula.
I Have 4 years of experience with Data entry, Data analysis, and MIS Management.
I have strong analysis, and Excel/google sheet skills and am able to provide solutions to most Excel/google sheet problems, including VBA programming.
If you work with me you will get good value for your money and a flexible approach to carrying out your work. I am great with deadlines and I will keep you updated throughout the process and the quality of my work is high.
Please Ping me the chat box for further discussion
Thank You
Hi, There
I am ready to start right now
I am excel formula expert
I am apply VLOOKUP perfectly and give you best result
as per your needed
Drop me a message so that we can discuss more
Thanks
Anowar
Hi There,
checked the Project : Need to get Rates based on INDEX+MATCH or CSE or VLOOKUP Formula
I carefully read the project description and i can handle this in my best practices and professional manner.
Please message me to discuss the work.
Regards,
Sunita
Hi, your file is done. If you're interested then tell me how to send this file to you. I've converted your sheet rates to named range table for easy linking data. Thank you
Hi there, my name is Ashraf and working as an Academic researcher, I have a master's degree and seven years of experience in the Academic Field and date entry. I can do this project with 100% accuracy and available to start working on it now. I can give you an example now before starting to work
.
Best regards.
Ashraf.
Hi,
Kindly, I work on many projects like your request, I can send to you many samples of my work in Excel chart, Formulas, Pivot table, and VBA codes.
Please let me have a chance to show you my experiences.
Please, don't hesitate to call me any time.
Hey there,
Hope you are doing well.
I would like to tell you that I have working in excel formulas for the last 6 years.
Briefly, I have looked into the files attached and figured out the solution of your problem, I have formulated the solution by using the IF Functions.
I will share you the file once you award me the bid.
Thanks,
Tayyba
Hello,
I am software developer more than 10 years. I have developed desktop apps with Vb.Net and MS SQL database in my first job. I have co worked with senior software developers of Microsoft. I was a member of team which have developed national vehicle registry software. I have hands on experience in object oriented programming, multi threading, web services, relational database design. As a freelancer, I have completed tasks about C#(Win32),VB.Net(API/JSON),Java(Optimization Software), Python-Script development-fix and Excel/VBA fix. Additionally I have golden badge on problem solving at HackerRank(python).
I have checked attached excel file. I can implement requested formula by Excel-VBA macro.
Regards.
Hello, I can help you with your proposal work . I can assure, you will get an authentic work from my side and I can finish the task at the given time.
Thanks.
The work which you have proposed will be done as per your wish and as soon as possible your work will be taken as a major responsibility for us the work will be done with the fullest dedication
