i need somebody who can run a formula to import the category id and category parent number's and match them with the category names from 2 different spreadsheets.
I have an existing master excel spreadsheet that i use for categories to populate my website.
I now have a new spreadsheet with more categories - that i need to match up with the existing sheet.
I require an excel expert to help create 2 new columns in the new spreadsheet for the categories to import the relevant matching numbers from the existing spreadsheet.
this will involve using data from 2 seperate spreadsheets
There are some categories that will be new and will not exist on the master spreadsheet. they should still import the relevant NUMBER to match the category PARENT ID - but leave the category id blank (as its a new category)
master spreadsheet has the numbers in 2 columns : Category ID and Parent ID
this is the second help i require on the spreadsheet there will be many more projects.
42 freelancer đang chào giá trung bình £17 cho công việc này
Hi My name is Dan. I am an expert in excel and I can do this formulafor you right away. Please message me and share the actual files so that we can proceed further. Thanks! Regards, Dan