Completed

I need an Excel Expert

Hello. I need an expert to create a formula that will align and match like values amongst a row of different values. Some of the values will not match, but the majority will.

Here is my issue. I have a retail store and I use Shopify for the store point of sale (POS.) I use Stitch for my inventory management that links multiple sales channels including my POS. Stitch doesn't have a method to upload my barcode UPC's so I'm not able to do inventory using a barcode scanner.

In order to use the barcode scanner, I need to upload a CSV to Stitch with the POS barcodes. I need to have all the SKU's in the POS and all the matching SKU's in Stitch, align on the spreadsheet. Once they are aligned in the same order, I can match the Barcodes (UPC) with the correct Stitch SKU and upload the barcodes into Stitch.

Then I'll be able to scan barcodes to update my stock.

I was told by Stitch that this formula would work, but it doesn't.

Hi Chad,

The formula would look something like this:

=VLOOKUP(A2,Sheet1!A1:B5,2,0)

A2 would be the cell with the Stitch SKU

Sheet1!A1:B5 would be the range of cells to look for a matching Shopify SKU and the associated UPC

2 would be the column number where the UPC was

The SKU's in both columns should be in the order of the SKU, not the Variant SKU.

Please let me know if you have any questions.

Skills: Excel, Data Entry, Data Processing, Visual Basic, PHP

See more: need excel expert, need excel expert match columns, need excel expert create macro, i need an expert in english language that would help to grade my essay test, i need an expert in formatting word documents in australia, i need an expert on whmcs to make a very simple job, i need an expert, i need excel data entry, i need excel expert, i need seo expert for my, i need seo expert, i need someone that can take a spreadsheet that i already have and perform 2 functions, i need you to fill in a spreadsheet with data its an easy task to enter the data in excel sheet, i need you to fill in a spreadsheet with data you should be able to finish within 15 days the website and spreadsheet will be pr, i need you to fill in a spreadsheet with data, urgent i need an expert on grasshopper, www i need an expert to write my speech com, where can i hire excel expert, any company need excel expert from home, how do i find excel expert in sri lanka

About the Employer:
( 0 reviews ) Santa Clartia, United States

Project ID: #20581946

Awarded to:

Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed mor More

$30 USD in 1 day
(224 Reviews)
6.8

8 freelancers are bidding on average $16 for this job

bluesea1990

Hello Dear I have read your description carefully. I have full experience in Excel VBA,Macro and Web scraping. I hope to discuss more via chatting. thanks

$20 USD in 1 day
(47 Reviews)
5.8
bloowebs

Hello, I AM AVAILABLE RIGHT NOW. If you like we can discuss this project. I can fix the formula in original sheet. I am technology specialist with several years experience in the fields of Data Science, Web Developme More

$12 USD in 1 day
(43 Reviews)
4.9
usmanahsan901

Dear Client, Hope You are fine, As a professional app developer and OFFICE expert I have build so many apps on Excel and i have read your requirement and I can do this task We will discuss task in detail in Chat Reg More

$20 USD in 7 days
(4 Reviews)
2.9
alemarta92

Hi, My name is Alessio. I am experienced Data Analyst and Macro/Acces Developer. I have done similar jobs . I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, More

$15 USD in 2 days
(1 Review)
0.0
ramzanalam98

Hi,I am Ramzan and it will be my pleasure to assist you with this project. I have read your project [login to view URL] can expect from me I strong commitment to a deadline, the highest quality, and a fluid/friendly commun More

$10 USD in 1 day
(0 Reviews)
0.0
MDMAHABUBHASAN

Dear hiring manager, At first take my sincire respect.i have gone through your project [login to view URL] that iam able to understand that I have be enough skills to do the project. Here is some information about why I More

$10 USD in 3 days
(0 Reviews)
0.0
abbhii

I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Recently I have al More

$10 USD in 3 days
(0 Reviews)
0.0