Excel Data Look Up / Formula writing
£10-20 GBP
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".
Projekt ID: #7170016
Om projektet
42 freelancere byder i gennemsnit £14 timen for dette job
Hi, I can help you with this now. Just let me know when you're ready ........................................................................................
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
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
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
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
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
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.
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
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
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
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
Hello, I am interested in your offer and is ready to cooperate. I can create a program that will do it