Completed

Excel Formula for Product Variants

The spreadsheet is for bulk importing products to Shopify through the Excelify app.

The PRODUCTS worksheet contains the data that will be uploaded.

We need a formula for the variants in PRODUCTS AC:AH, which are pulled via VLOOKUP referencing the EAN in column C. The current formula provided in the workbook results in an upload error.

The criteria are:

- If a variant is "N/A", then Option Name and Option Value should be empty

- There will be an upload error on Shopify if Variant 2 is populated, but Option1 is empty. Likewise for Option 3, if Option 1 and 2 are empty and so on. i.e. the lowest Option number must always be 1. The formula should ensure the Options are created from 1 upwards.

- The formula should pull the relevant header from EPOS Brand List Worksheet to populate the Option Name column i.e. Size, Colour, Material

Addtional:

- Changes are only allowed to columns AC:AH in PRODUCTS worksheet.

Skills: Excel

See more: call web service excel formula, excel tiered product pricing formula, excel formula spreadsheet, excel formula spreadsheet spreadsheet, excel formula to compare two columns for matches, compare three columns in excel and return a value, product life cycle excel formula, convert excel formula to google spreadsheet, excel formula to compare two columns and return a value, how to split one column into multiple columns in excel formula, excel formula to find top 10 values in a column, excel formula to find top 10 values in a row, excel formula to allocate an amount into weekly columns, excel formula product of two columns, excel formula to allocate an amount into monthly columns, how to keep a cell fixed in excel formula, excel update formula when inserting columns, formula to calculate net worth of a company in excel, excel formula to count unique values in a filtered column, excel cross product of two columns

About the Employer:
( 2 reviews ) Lindfield, United Kingdom

Project ID: #27495947

Awarded to:

(183 Reviews)
6.0

15 freelancers are bidding on average £18 for this job

leelakalidas32

Hello sir Good evening how are you? i am expert in shopify products listing via csv bulk , if you need help then i can arrange your csv file so you can upload it directly to your store. contact me if you okay with my More

£20 GBP in 1 day
(586 Reviews)
7.6
(142 Reviews)
6.3
Mokshith30

Hi I am VBA Developer Experianced In Web Scrapping & VBA Macros I can finish this task in a day only please share the details thanks

£20 GBP in 1 day
(41 Reviews)
4.6
nelumindralal

Hello, I went thru the file and description Here is my feedback The criteria are: - If a variant is "N/A", then Option Name and Option Value should be empty--> 'EPOS Brand K value also N/A, its a value, not a non val More

£30 GBP in 1 day
(29 Reviews)
4.8
lotusvijay

Hi Good Day,~~~~~~I will start working immediately~~~~~ I can do this work.I am expert in Excel automation. I have 5+ years experience in [login to view URL] project completed in this site with 5 star rating. Look My Profile:htt More

£13 GBP in 1 day
(42 Reviews)
4.3
haleem0786

i can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please inbox me and share detail. Thanks Abdul Haleem

£20 GBP in 1 day
(28 Reviews)
4.2
Mohilm007

------------------I CAN DO IT RIGHT AWAY------------------ Hi, I am the professional and skilled worker in this field since last 6 years. I can help you with your project of data entry in excel, VBA, excel macros, VB, More

£15 GBP in 1 day
(4 Reviews)
3.3
chetandc

Hello, Thanks for Reviewing my Bid. I have understood your "Excel Formula for Product Variants" project. & I can fulfill your requirements. I have years of data entry, data formatting, processing, Ecommerce product l More

£20 GBP in 2 days
(18 Reviews)
2.8
himanshuprajapa6

Hi I'm Himanshu Prajapati, I'm new in freelancer.com. But still I have worked in other private companies. So I'm more experienced in Excel, word, pdf to word conversion and Data Entry work. I have just seen that you ne More

£15 GBP in 7 days
(0 Reviews)
0.0
Zeeshaan6061

Hi, Lets Get Started With This right Now……This is pretty straightforward task……and I can do this as u want it done…..will fix it asap :) I have done many projects similar to this…all with 5* feedbacks, hope will get a More

£10 GBP in 7 days
(0 Reviews)
0.0
Lockest

Hello. I'm an engineering student and I've worked as an administrative assistant for two years now. I'm confident I can develop the formula you need, and I'd compromise to fix it if any issue would arise in the follow More

£15 GBP in 5 days
(0 Reviews)
0.0
Subathrasiva

hi.... right time to work with you....I know Excel sheet for the work.... eager to work with you. tq ...I am waiting

£34 GBP in 6 days
(0 Reviews)
0.0
mpanigrahi2892

I can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please inbox me and share detail.

£10 GBP in 3 days
(0 Reviews)
0.0
Nazeer0010

Hi, To be frank I did not get the requirement, I'm really good in playing with excel formulas. If you can give me little more brief I'll give you the output in same day. Thanks, talk to you soon.

£10 GBP in 1 day
(0 Reviews)
0.0