Find Jobs
Hire Freelancers

Multiple Rates as per Weight brackets

$10-30 CAD

완료함
게시됨 4년 이상 전

$10-30 CAD

제출할때 지불됩니다
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
프로젝트 ID: 21681920

프로젝트 정보

6 제안서
원격근무 프로젝트
활동 중 4년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
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
$10 CAD 1일에
5.0 (191 건의 리뷰)
6.8
6.8
6 이 프로젝트에 프리랜서들의 평균 입찰은 $25 CAD입니다.
사용자 아바타
$ 15 CAD Only ---- In just 6 Hours ----- Data Entry, Web Scrapping, Excel VBA Macro Coding and Formula Generation Expert
$15 CAD 1일에
4.9 (28 건의 리뷰)
3.8
3.8
사용자 아바타
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.
$20 CAD 5일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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
$25 CAD 1일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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
$30 CAD 1일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (CANADA)
Mississauga, Canada
0.0
0
결제 수단 확인
10월 8, 2019부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.