I need an Excel Expert
Budjetti $10-30 USD
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.
8 freelanceria on tarjonnut keskimäärin 16$ tähän työhön
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
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 Lisää
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, Lisää
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 Lisää
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 Lisää
