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.
The formula would look something like this:
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 freelancers are bidding on average $16 for this job
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