Write an Excel format to search text strings and return corresponding data

$10-30 USD

Completed

Posted

about 7 years ago

$10-30 USD

Paid on delivery

Quick project to write an excel formula. I need it within two days- by this Friday. Basically I have a normal contact datasheet with First, Last, Title etc, and another excel file with a text string and corresponding location that contains the text in the datasheet. I want to add this location to the contact file. So, I've added a Firstname+lastname column and I'm trying to reconcile the text string and corresponding location with the other contact information. I need a formula that will search the name of the contact in Column C in the text string in column D and return the corresponding location in column F. See picture of how I have the data now attached I've use a variety of formulas with VLOOKUP, INDEX and MATCH but with no luck. The need for it to find the text in a string makes this tricky. Please confirm you can do this project within two days.

Excel

PHP

Software Architecture

Project ID: 13780178

About the project

13 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel projects and i've never had a single problem. If you are interested please send me a sample file/s so i can see what exactly needs to be done (only few rows is enough). Usually i can complete "comparison" projects like this one pretty quickly. As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect. Thanks, Milan

$20 USD in 0 day

5.0

(431 reviews)

6.8

13 freelancers are bidding on average $25 USD for this job

@FINGERRPRINT

Could you please share the file, so I can try and come up with the solution. Very good in excel and its formula's. Thanks

$30 USD in 1 day

4.9

(204 reviews)

7.5

@P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 USD in 1 day

4.9

(275 reviews)

7.2

@rohitagarberg

Hi sir, do you need the formula or the final data correctly mapped will do. thanks....................................

$15 USD in 1 day

5.0

(554 reviews)

6.9

@DMcCarthy89

Hi, I am a scientist by profession, and have extensive experience in creating Excel formulas to pull required data from large or complex datasets. I have looked at the image you provided, and I already know how to write a formula which will accomplish what you need. Please see my portfolio for some previous examples of my work, and don't hesitate to contact me if you have any questions. Thanks for your consideration, Dan

$25 USD in 1 day

5.0

(49 reviews)

5.1

@Ramez125

Hello I am with more than 3 years experience and I can help you to do your job accurately, quickly and with high quality, available 24/7 to support you and promise I will meet your expectations. Regards

$25 USD in 0 day

4.8

(26 reviews)

4.4

@nlimits

CAN DO IT TODAY! Dear sir, I have wide experience in the area of Software Engineering, Big Data, Data Analysis and Data Processing. So, I am pretty comfortable that my Data Processing knowledge will be sufficient to accomplish your job fast and with high quality. I am new as a freelancer here, but it should not be an issue. Since I need some feedbacks from employers at this stage, I am bidding a lower price. Thanks

$15 USD in 1 day

5.0

(4 reviews)

3.6

@globatic

Dear, I would like you to hire me to perform this excel data mining project. With more than 10 years experience in excel data ming, I'll perform this job quickly and accurately. You' pay me $25 at job success or aproval. I' m waiting to to be awarded this job. I'm waiting to hearing from you soon. Best regards. Balouki ADEWI.

$30 USD in 3 days