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

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.

Kemahiran: Excel, PHP, Kejuruteraan Perisian

Lihat lagi: data entry text jpg format, convert text excel format, data uae companies excel format, uae business data directory excel format, copy date values format text excel, excel format number text csv, excel vba search word text, import historical data excel format, sample supplier data base format excel format, filemaker data excel format, entire bible text excel format, excel data entry regular hour format, howto export data csv excel format php mysql, copy date text date format excel, excel vba return xml data type

Tentang Majikan:
( 7 ulasan ) San Diego, United States

ID Projek: #13780178

Dianugerahkan kepada:


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 Lagi

$20 USD dalam 0 hari
(424 Ulasan)

13 pekerja bebas membida secara purata $25 untuk pekerjaan ini


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 dalam sehari
(274 Ulasan)

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 dalam sehari
(204 Ulasan)
$30 USD dalam sehari
(204 Ulasan)

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

$15 USD dalam sehari
(538 Ulasan)

we have expertise in excel VBA,data [login to view URL] satisfaction is our main motto for long term relationship.

$20 USD dalam sehari
(69 Ulasan)

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 w Lagi

$25 USD dalam sehari
(49 Ulasan)

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 dalam 0 hari
(26 Ulasan)

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 Lagi

$15 USD dalam sehari
(4 Ulasan)

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 aprov Lagi

$30 USD dalam 3 hari
(1 Ulasan)

I didn't see the attached picture. Can you send another one. I'm interested to do this.

$38 USD dalam sehari
(0 Ulasan)
$20 USD dalam sehari
(0 Ulasan)

Very confident I can provide you with a solution to this by noon tomorrow

$25 USD dalam sehari
(0 Ulasan)