已完成

Excel Formula Auto Select Shipping Method

Excel Formula Auto Select Shipping Method

Task:

Using excel functions such as index, match, offset, create a formulae to retrieve the correct shipping methods for 2 columns based on the stated rules.

The formulae must be robust and have versatility if referenced columns are moved and deleted it will not make the formulae error, i.e. vlookup formulas are not appropriate.

Specifications

2 Columns:

Note:

For the 2 columns you will need to reference the formulas to either Product_ID or POA_ID.

If POA_ID exist the reference to this, if does not exist then reference to Product_ID

Lowest Tracked Shipping Method column:

Search through shipmethod_name_1 to shipmethod_name5

If shipmethod_name_1 equals the following then return that shipping method

Air Parcel Register

LC_SHIPMENT_NZ_DIRECT_MAIL

EMS Express Mail Service

Expedited Shipping Service

If shipmethod_name_1 to shipmethod_name5 only has Standard Shipping then return “Standard Shipping”

Selected Method (High Value items > $X) column:

If Lowest Tracked Shipping Method column is EMS Express Mail Service or Expedited Shipping Service method then return this figure back

If the product_price is less than specified high value items figure then return method from Lowest Tracked Shipping Method column

If product_price is greater than or equal to the specified high value items figure then return:

The next (to the next right side column) EMS Express Mail Service or Expedited Shipping Service method

If the above 2 methods do not exist then return:

The next (to the next right side column) Air Parcel Register or LC_SHIPMENT_NZ_DIRECT_MAIL

If the above 2 methods do not exist then return:

Standard Shipping

技能: Excel, Excel VBA, Excel Macros, Excel VB Capabilities

查看更多: virtuemart error please select shipping method, select shipping method virtuemart, joomla select shipping method problem, unable ship usps error select shipping method , please select shipping method virtuemart, please select shipping method, error please select shipping method, error please select shipping method virtuemart error, auto update shipping method cart magento, select shipping method error virtuemart, paypal select cheapest shipping method, auto select shipping magento, excel formula to compare two columns for matches

关于此雇主:
( 4个评论 ) Auckland, New Zealand

项目ID: #20285008

授予:

urielbaray

Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sampl 更多

$25 NZD 在7天内
(34条评论)
5.1

25 威客就此工作平均出价 $31

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl 更多

$30NZD 在1天里
(307条评论)
7.9
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formu 更多

$40 NZD 在7天内
(84条评论)
6.6
aubrey03

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] 更多

$30NZD 在1天里
(116条评论)
5.9
c4cuteconain

I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for this project. Please send me a message and we can move forward with your pr 更多

$22 NZD 在7天内
(49条评论)
5.5
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects i 更多

$90 NZD 在3天内
(63条评论)
5.6
valor312

VERY EASY FOR ME Hi, Nice to meet you. When it comes to Excel, I am an expert Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.com/projects/excel/Build-apprais 更多

$50NZD 在1天里
(31条评论)
5.3
xinglong717

I have many experiences in Excel. I can show you my projects via chatting. I can complete your project successfully. Thanks.

$22 NZD 在7天内
(9条评论)
4.1
writingapp

Hi. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile

$15NZD 在1天里
(5条评论)
3.3
rashedkhanrubel

Hi, I have understand the project description & interested to work for this project. I can make the condition for this project as required. Please send a message so we can discuss more & start the project. Thanks.

$22NZD 在1天里
(6条评论)
3.0
Rasel2543

Hello there, I have read your project description very carefully. I am excel expert. I am good at Excel formula, VBA, Macro. If you want to done your task perfectly and accurately then please contact me. Hope to hear 更多

$14NZD 在1天里
(9条评论)
3.2
sergeyprince

Hello. I can do your project perfectly. I have got 8 years of rich experience in VBA. I can do VBA programming as fast as you want. I am Data Processing, Excel VBA Expert who knows the value of time, very hard workin 更多

$20 NZD 在7天内
(9条评论)
2.4
ninestar801

Hi, Hope you are doing well! I would like to work on your project. I have excellent in skills with more than 6 Years experience. I'm sure that I will complete with high quality in the shortest time. I am always availab 更多

$122 NZD 在7天内
(5条评论)
2.5
Coworkingeng

Hello According to our experience, this will be an easy job for us. We can prepare the project in less than a day for you. We recently started working as freelancers and we need to upgrade our rankings on the site by d 更多

$30NZD 在1天里
(2条评论)
1.0
godming728

Hello, my name is Andrei. Thank you for considering my bid. I'm confident that I have the necessary skills and experience to complete your project. I will take time and always carefully listen to your needs and questio 更多

$22NZD 在1天里
(1条评论)
0.8
imad55497

I will help you. my name is Imad I'm from Morroco. ..............................................................

$22 NZD 在7天内
(0条评论)
0.0
shan4612

I have checked your requirements and it's very simple I have an experience of 6 years with data base management along with this I can help you with a lifelong automation solution and database housekeeping solution

$19NZD 在1天里
(0条评论)
0.0
dogolecha

My understanding about the work is what makes me an excellent candidate to hire as a freelancer. I have worked on a project very similar to this before, and I am sure that I can replicate its success while working on t 更多

$22 NZD 在7天内
(0条评论)
0.0
KernelExplorer

Hello, I am skilled developer, experienced in different projects such as decompilators, fraud analitics and GUI application making. I am new in freelance thats why I working with small tasks. Choose me and you will not 更多

$14NZD 在1天里
(0条评论)
0.0
KhaledMS7

Hello, I am CMA certified, I hope to get this job to be one of my first jobs. I am very professional using excel, attain to detailed. I used to process such tasks as I worked with international companies for a long pe 更多

$30 NZD 在3天内
(0条评论)
0.0
magadan9

MY NAME IS TANIA, I AM A RESPONSIBLE, ETHICAL AND RELIABLE PROFESSIONAL. I ALWAYS DELIVER MY PROJECTS IN TIME AND FORM. I HAVE 19 YEARS OF WORK EXPERIENCE. I CAN IMPROVE THE WORK COST AND DELIVERY TIME THAT YOU OFFER.

$30 NZD 在7天内
(0条评论)
0.0