In Progress

Need excel function to replace old with new

Hello,

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..

example:

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

Thank you.

Skills: Data Processing, Excel

See more: numbers function, number function, marketing angel, function of numbers, function numbers, function number, family id, example thank you letters, books and authors, marketing authors, list of book and authors, i need an author, sue, old letters, marketing letters, excel function, excel doe, doe excel, urgent need formula solve equations unknowns excel need, excel need bank, matching excel, excel need import skype, excel data matching, excel bet angel, excel matching

About the Employer:
( 24 reviews ) Sacramento, United States

Project ID: #5773527

Awarded to:

GuruExcel

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.

$2 USD / hour
(2 Reviews)
1.4

23 freelancers are bidding on average $4/hour for this job

RSwapnil

Hello, I can write the formula for your requirement in excel. About Me: I am working as individual at Freelancer and I have vast experience of data entry, Research, web scraping & copy/paste projects as I am wor More

$3 USD / hour
(56 Reviews)
5.5
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$8 USD / hour
(38 Reviews)
5.2
SoftwareEng8876

Hello...Would you can just click on discuss button and start chat with me..Would you like,Discuss project with [url removed, login to view] can negotiate about price,time and work. ... Let me do it......I am software engineer....Thank you..

$21 USD / hour
(25 Reviews)
4.7
MimiFL

Hi, i m serious freelancer with 100% completion rate, and this is very simple formula. This is formula for cell C2, just expand this formula for all other cells. =VLOOKUP(B2, Author!$B$2:$C$8, 2, FALSE) Please t More

$2 USD / hour
(24 Reviews)
4.3
yes0

I LL DO FOR 25 USD FIXED PRICE ... COMPLETE TODAY I read through the job details extremely carefully and understand you’re required, for this I am absolutely sure that I can do the project very well. I can complet More

$8 USD / hour
(26 Reviews)
3.8
Khurramz

A proposal has not yet been provided

$5 USD / hour
(12 Reviews)
3.7
elqueabandona

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.

$5 USD / hour
(4 Reviews)
3.2
faheems189

Hello sir. i have good experience in MS-OFFICE. i have done many project for chart and formula applying in excel. i can make this function for you. but i need 2 days to be done this task. awaiting for your positive res More

$5 USD / hour
(7 Reviews)
3.1
softkiran

Dear Sir, It is less than 1 hrs work for me, please give me a opportunity to serve you. Thank You, softkiran

$2 USD / hour
(1 Review)
0.8
SKBS

Hi! Get done for $5 .

$5 USD / hour
(1 Review)
0.0
tbzahid

A proposal has not yet been provided

$2 USD / hour
(0 Reviews)
0.0
zia76

Hello,I've gone through your job posting and very much interested to work with you. I'm punctual and hard working person.I feel very comfort in MS [url removed, login to view] I've a lot of free [url removed, login to view] I think I can support you on this More

$2 USD / hour
(0 Reviews)
0.0
rk2405

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.

$2 USD / hour
(0 Reviews)
0.0
Riz29

Hi. Please give me a chance to do this job. Please i am free i can do this job immediately. Kindly om me i am waiting. Award me this project so i start my work. Give me a chance to show my skills. Thanks in advanc More

$2 USD / hour
(0 Reviews)
0.0
Tiffanymj88

I have several years of experience in a variety of fields including working as an administrative assistant. In addition to my extensive office experience, I have strong communication, customer service, and administrati More

$6 USD / hour
(0 Reviews)
0.0
idelvice

I'm interested in the position that you recently posted. I have all the qualities that you are looking for, and my jobs profile correctly matches with the requirements you had mentioned. I have all the skills for the j More

$5 USD / hour
(0 Reviews)
0.0
hinahanif15

Greetings, I am interested in working on this excel project. The work will be correct and done soon. Hoping to hear soon from you to discuss further details.

$5 USD / hour
(0 Reviews)
0.0
rjordan217

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 :)

$2 USD / hour
(0 Reviews)
0.0
mfaisalgujjar297

sir, sir i can provide this work [url removed, login to view] send the all detail about this project and give me chance for thank you.

$5 USD / hour
(0 Reviews)
0.0
akhtarhussain86

A proposal has not yet been provided

$5 USD / hour
(0 Reviews)
0.0