Excel spreadsheet expert required
£10-20 GBP
Paid on delivery
hi there
I have 2 spreadsheets that i use for my website.
One spreadsheet for my products and one spreadsheet for my product categories
The products are matched to the correct category by the category id number.
however in my new web shop they need to be matched by the category name (not id number)
so i need somebody who can run a formula to replace the category id number with the category name.
this will involve using data from 2 spreadsheets.
Category id number in the product spreadsheet - must be replaced by the category name from the category spreadsheet.
Some products belong to more than one category and they categories are seperated by a | character. This should stay the same.
thanks !
Project ID: #12825562
About the project
Awarded to:
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
37 freelancers are bidding on average £15 for this job
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among More
Hi, I am good at Excel and vba. Plz provide me the details further to get the scope of work. Looking forward to discuss in the chat.
Hi, I can get category name for category id's by using vlookup. Hope you would consider my bid and send the spreadsheet. Thanks FINGERRPRINT
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More
Hello. I am good at excel and able to deliver quality work. Can you please provide your source file? Best regards, Hoang
Hello sir, just saw your project description and you are looking for a freelancer to replace category id in the product sheet with category name in the category sheet. I have experience working in this field for 4 year More
Dear Davidmac007, I can start now to run a formula to replace ID with category. I don't have any work for this time, so i can spend all my time. I have completed some excel project before, feel free to review my pr More
Hi sir, i will combine the two sheets using category name instead of id. ready to start now. thanks....
Hello, It will be my pleasure to assist you in this project. I'm excel expert and I can do this soon form you. Kind regards, Luis Romero
I have excellent command on MS Excel and complete this task within a day. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a reservation system More
Hi, Experienced Excel Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating Data from Multiple Sheets. I can create a button and will give you More
Hello I am with more than 3 years experience and I can help you to do your job accurately, quickly and with high quality, available 24/7 to support you and promise I will meet your expectations. Regards
Dear Sir, I am an MBA with strong grip on MS Excel. Working in excel is part of our routine, I have handled data of more than 3000 entries, worked on stock analysis, developed operational model for a satellite company More
Hi, I can help you to get this work done perfectly. I have a great command over excel and can do this work by using excel function effectively. I am able to start work immediately and can deliver the work accordingly w More
This box has limited space and no provision for attachments. I am Mechanical Engineer, proficient in MS Access, Excel Macro, Pivot Table/charts with slicer, dashboard, functions and formulas. About Myself Goo More