Excel Data Look Up / Formula writing

Færdiggjort Opslået Feb 19, 2015 Betalt ved levering
Færdiggjort Betalt ved levering

A nice simple quick project for an experienced Excel person!

I have a simple set of data in excel. Column A is a list of unique items. Column B are a random set of numbers that are associated to Column A. Column C is a set of unique items that are present in Column A, but do not relate to column B numbers. I want a formula where if data in column C is present in Column A, it will take the horizontal matching Column A number in Column B and place it in a new column D.

The formula should allow me to add more data into Colum C and contiun to produce results in Column D. If for some reason data in Colum C is not present in column A, then it should present the result of "Not Present".

Excel

Projekt ID: #7170016

Om projektet

42 bud Remote projekt Aktiv Feb 20, 2015

Tildelt til:

akrikun

Hi. I've separated your data into columns and have written the required formula for column D. Refer to the screenshot: [login to view URL] Please contact me if my bid su Flere

£10 GBP in 0 dage
(7 bedømmelser)
3.2

42 freelancere byder i gennemsnit £14 timen for dette job

Vlzinch

Hello! I cam make this asap in one hour(maybe less). Regards, Vlad Zinchenko

£13 GBP på 1 dag
(65 bedømmelser)
7.8
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr Flere

£14 GBP på 1 dag
(333 bedømmelser)
8.0
motiur03

Dear Hiring Manager, I am writing in response to your advertisement for a “Data Entry Assistant ”. After carefully reviewing the experience requirements of the job description, I feel that I am perfect for this job Flere

£17 GBP på 1 dag
(262 bedømmelser)
7.8
zExcel

Hi, I can help you with this now. Just let me know when you're ready ........................................................................................

£22 GBP in 0 dage
(251 bedømmelser)
7.7
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards

£18 GBP in 0 dage
(296 bedømmelser)
7.3
khushh07

Hi I have seen your job post and understood your requirement . I can do the job you posted within given time frame with maximum accuracy, and looking forward to work with you for longer period of time. Thanks Khu Flere

£20 GBP på 1 dag
(318 bedømmelser)
7.3
eltamarisa85

Dear a996 , i can start now to create a formula for your excel file i have read and i understand what you want. i don't have any work for this time, so i can spend all my time. i have completed some excel project Flere

£10 GBP in 0 dage
(268 bedømmelser)
7.0
priyal1997

Dear Sir/Madam, I can to this perfectly for you and once you are done, you can offer me the job.I am ready to start this immediately and waiting for your reply. Best regards Priyal

£20 GBP på 1 dag
(185 bedømmelser)
6.7
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Flere

£20 GBP in 0 dage
(162 bedømmelser)
6.5
gokulanand

Hello, I can get you a macro written for this task which you can reuse in the future. I can get it done immediately within an hour or so. Let me know if you are interested. If you agree to create a hourly project Flere

£15 GBP in 0 dage
(113 bedømmelser)
6.1
dpune

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

£20 GBP in 2 dage
(115 bedømmelser)
6.3
adityasl

Hello I am ready with the macro. Looking forward for the reply. Regards Aditya

£10 GBP på 1 dag
(121 bedømmelser)
5.3
rumarahman

Hi, I am an Excel expert and is ready to start work for you right now. Please PM to me. Thank you. Best Regards, Ruma.

£13 GBP in 2 dage
(51 bedømmelser)
5.4
denisaelena

Hi sir, I solved your file, ...bcause it's such an easy job...I'll give you the formula... if you want you can award me the project after that, if not you can uset free... =IFERROR(VLOOKUP(C2;A2:B10941;2;FALSE Flere

£18 GBP in 0 dage
(21 bedømmelser)
5.2
wbslivera

Hello, I am Oracle certified professional java programmer and have BSc,IT, I can help you here as I helped you before, let me know, thanks

£18 GBP på 1 dag
(22 bedømmelser)
4.4
rajafaizan

Hello sir... i guarantee you 100% satisfaction and my expertise lies in quality service and delivery on Time kindly if you wants high quality work then as soon as possible contact me. Please give me chance to prove mys Flere

£18 GBP på 1 dag
(28 bedømmelser)
4.5
swatiag1101

Hi, I am an Excel expert and can write the Excel formulas to search the value in Column C in Column A, and put the corresponding value from Column B in Column D. I can also add any other functionalities that you wan Flere

£10 GBP på 1 dag
(9 bedømmelser)
4.1
dank111

Hi, My name is Dan. I am an expert in excel and all advanced functionalites. I can get this formula to you instantly. The formula can be used on any new rows. Please message me so that we can proceed further and Flere

£13 GBP in 0 dage
(10 bedømmelser)
4.3
nahilbd

Sir, I am ready to start your work. I am sincere. Please check my profile. I have completed a formula =IF(C2=A2,A2&-B2,"NOT PRESENT"). Please check it and inform me if change need. It will if data in column C is pr Flere

£10 GBP in 0 dage
(13 bedømmelser)
3.8
MykolaDudych

Hello, I am interested in your offer and is ready to cooperate. I can create a program that will do it

£18 GBP in 2 dage
(8 bedømmelser)
3.5