Færdiggjort

Excel spreadsheet expert required

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 !

Evner: Excel

Se mere: expert in excel required dublin, load data excel using asp, filter data excel using vba, virtual assistant, excel, visual basic, web scraping, web search, internet research, visual basic for apps, personal / virtual assistant, reading using data excel, copy data internet explorer excel using macro, export sql data excel using aspnet, bowling tournament spreadsheet excel, copy internet explorer data excel using vba, import project data excel using vba, copying pasting excel spreadsheet excel spreadsheet, excel copy data spreadsheet macro, required expert linnux nashik

Om arbejdsgiveren:
( 51 bedømmelser ) UK, United Kingdom

Projekt ID: #12825562

Tildelt til:

watersev

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene

£11 GBP in 0 dage
(231 bedømmelser)
6.3

37 freelancere byder i gennemsnit £15 på dette job

jaylancer43

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 Flere

£20 GBP in 0 dage
(536 bedømmelser)
8.1
cgullapalli

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.

£13 GBP in 0 dage
(612 bedømmelser)
7.6
schoudhary1553

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 Flere

£20 GBP in 0 dage
(210 bedømmelser)
7.2
FINGERRPRINT

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

£20 GBP på 1 dag
(164 bedømmelser)
7.3
MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel projects (with both formulas and macros) and i've never had a single problem. If you are interested please Flere

£14 GBP på 1 dag
(327 bedømmelser)
6.6
nomannaumi

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 Flere

£14 GBP på 1 dag
(48 bedømmelser)
6.7
hdlong66

Hello. I am good at excel and able to deliver quality work. Can you please provide your source file? Best regards, Hoang

£14 GBP på 1 dag
(110 bedømmelser)
6.7
semi786

Hi Sir/Mam, It is being my pleasure to introduce you to me. I have taken a look at your project description and I'm confident that we can work together. I am expert in advance excel. I have good knowledge of excel a Flere

£12 GBP in 0 dage
(116 bedømmelser)
6.5
eltamarisa85

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 Flere

£18 GBP på 1 dag
(204 bedømmelser)
6.7
mrbrave

Hi, I am highly experienced Excel user and can complete this job within few minuites. I am available to to start and comple.. Please also send a spreadsheets to view the structure. It will help in understanding Flere

£19 GBP på 1 dag
(195 bedømmelser)
6.5
dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Plea Flere

£20 GBP in 3 dage
(115 bedømmelser)
6.2
rohitagarberg

Hi sir, i will combine the two sheets using category name instead of id. ready to start now. thanks....

£13 GBP på 1 dag
(220 bedømmelser)
5.9
£13 GBP på 1 dag
(122 bedømmelser)
5.9
£10 GBP in 0 dage
(42 bedømmelser)
5.2
archanaoswal

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 Flere

£15 GBP på 1 dag
(23 bedømmelser)
4.7
royalcalif

Let me have the spreadsheet I will do towards to your requirements. Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your require Flere

£10 GBP på 1 dag
(40 bedømmelser)
4.9
beltran0404

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

£10 GBP in 0 dage
(72 bedømmelser)
4.9
vsprybhanu

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 Flere

£20 GBP på 1 dag
(43 bedømmelser)
4.7
Ramez125

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

£11 GBP in 0 dage
(25 bedømmelser)
4.4
fawadrafique

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 Flere

£16 GBP på 1 dag
(40 bedømmelser)
3.9