Fix an Excel spreadsheet with 5 Sheets with VLOOKUP
$30-250 USD
Paid on delivery
Please download example file and familiarize with it.
I have a spreadsheet with 5 worksheets on it. Each Sheet contains data from online purchases from different marketplaces (Amazon, ebay, alibris, shipstation). Each marketplace gives us a tracking number for the item. Sheet 2 (AbeOrders) contains a full list of items with relative order numbers. Each item has been purchased on one (and only one) marketplace.
I need to create a Sheet called "All", which will have the Date, order number from AbeOrders followed by item description and all tracking numbers so I can easily retrieve the tracking number from the correspondent marketplace.
All order numbers come from AbeOrder Sheet.
For example order number 550174038-174 (Planet of Youth book) was bought on ebay and tracking number is 9449011899561017983200. I know this from the ebay sheet. On Tab "All" I should see the tracking number in ebay column next to the Item name.
It is possible sometimes that Shipstation sheet AND another channel (like Amazon) have both tracking numbers: in that case they should be reported both on Sheet "All".
You can find the matching rows with 2 criteria:
1 - by Order number (in red)
2 - by Item name (truncated at 30 characters in Yellow)
For example Order number 550174038-174 can be searched on shipstation by its order number, but on amazon only by its title "Planet of Youth..."
The goal is to have the "All" sheet with all Date, order number, item name, with tracking from one marketplace plus shipstation (if available.)
Amazon sheet needs to have item name truncated at 30 characters.
At the end you should show me how to do this with new data that I will be occasionally addying to all of the tabs except the "All" tab.
This can be achieved with VLOOKUP. Please dont use macros since this sheet will be opened on many different versions of excel. NO MACROS OR VBA.
Project ID: #24256583
About the project
Awarded to:
Dear sir I will create the vlookup function in All sheet in such way the column which have that value in its sheet will show the value. I have been in this industry for 1 year and such jobs are my daily practice. I ca More
12 freelancers are bidding on average $72 for this job
Hello, I am Rahul. I have gone through your project details; you need to Fix your Excel spreadsheet with VLOOKUP I am Expert in Microsoft Office (EXCEL, POWERPOINT, WORD), Data Scraping, Data Entry, Translation, Video More
Hi, I will use Vlookup formula and get your results from 5 sheets. I have read your project description and I feel I will be right choice for you for this project. I am certified from ALISON for Microsoft Office sp More
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myse More
Hi, I've download your file and I'm trying to make what you need. I'll inform you in 15 minutes I think, but it will be easier if you reply my chat so we can discuss. If you don't reply me I only can contact you by cha More
Hi there My name's Benne and I have helped thousands of people via Excel forums, trainings, and consultancy projects. I like to read up my clients' requirement before placing a bid, but they are frequently closed for More
HI SIR I am available right now I've read your job description carefully. I can do your project very well. My goal is to deliver high-quality work. If I can provide you with service, I would be proud. If you need high More
Hi, I just saw the job post that you are looking for an SEO OPTIMIZATION for a website for your conference Schedule. I have seen your attachment. I am specialized in Search Engine Optimization, social media marketing, More
Try me out for free Try me out for free Try me out for free Try me out for free Try me out for free Try me out for free
Hello sir, I am new freelancer but I am professional in this field and I will do your task as soon as with accuracy . Thanks,
