I have an excel sheet with name of books and authors, however Authors are given a id # and recently we changes their Id number.
so the Issue is the Book titles are listed like the excel sheet attached and we would like a function were the new author ID # shown after matching the old ID numbers..
Excel Author list:
Author Old ID # New ID #
John Doe 4 1
Paul Angel 8 2
Sue Case 1 3
Book title Sheet:
Author Author ID # (old) Author ID # (new)
Marine Pollution Bulletin 8 "function to list new ID #"
Marketing Intelligence and Planning 1
Marketing Letters 1
Marriage and family living 4
I am excel expert and can complete this task for you. I can start immediately and will be able to complete it very fast. Message me if you need any clarification.
23 freelancers are bidding on average $4/hour for this job
Hello...Would you can just click on discuss button and start chat with me..Would you like,Discuss project with [login to view URL] can negotiate about price,time and work. ... Let me do it......I am software engineer....Thank you..
Hello, my name is Cristian, I have a degree in Business and I work with excel every day, I have experience in creating complexed formulas, to obtain information for decision-making. Chat with me greetings.
I'm a new freelancer here. So, I need an opportunity to prove my worth. I have been familiar with data processing and I can do your work at minimum time with maximum effectiveness and minimum cost too.
Hello, I have designed numerous excel matching programs to accomplish similar functions; I would be able to finish this project very quickly and efficiently. In fact, I have already written the program :)