Find Jobs
Hire Freelancers

Create an Excel Formula

$10-30 USD

Completed
Posted over 3 years ago

$10-30 USD

Paid on delivery
I need an Excel formula that searches for a list of text strings (located in in Sheet2 Column A) in a cell, and returns the related value in Sheet2 Column B and concatenates them into a single cell in Column G. This is a very long list of possible values to return-there will be several hundred possible text strings I need returned and concatenated with a comma into a single cell. See example file attached.
Project ID: 29170991

About the project

43 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

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:
User Avatar
Hi, As I understand you would like text present in col A of sheet2 to be searched in col E of first sheet and if found match with corresponding return value of col B in sheet 2 and then concatenate the results in col G of sheet1. I can help with Excel macro which on click can complete the task for you. Looking forward to your response. Thanks
$20 USD in 1 day
4.9 (133 reviews)
6.5
6.5
43 freelancers are bidding on average $21 USD for this job
User Avatar
Hi, it will be a quick turnaround! I can create a formula, which will searche for a list of text strings (located in in Sheet2 Column A) in a cell, and returns the related value in Sheet2 Column B and concatenates them into a single cell in Column G will you please send me a message to discuss it and get started? :) Thanks, RK.
$25 USD in 1 day
5.0 (211 reviews)
6.7
6.7
User Avatar
Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 1 hour
$20 USD in 1 day
4.9 (107 reviews)
5.9
5.9
User Avatar
Pleasure to help you. Excel automation is my masterpiece in my accounting field. feel free to message me to start the job. Thank you so much
$25 USD in 1 day
4.9 (72 reviews)
5.6
5.6
User Avatar
Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 61 projects on FL. Expertise in - • Macros • Formulae • VBA • User forms Willing to share a sample of my work done on various excel applications on this platform. Looking forward to hearing from you. Thank you BAVarun PS: Please have a look at the reviews given to me on this platform. PPS: The price indicated in the bid is generic in nature. It may change basis on the scope of work post our discussion
$20 USD in 1 day
4.9 (54 reviews)
5.3
5.3
User Avatar
Dear Sir/Madam I am accounting and EXCEL expert as I am Chartered Accountant(ACCA) and expert in QB, XERO and EXCEL. You can see my profile I do have the relevant skills to do the assigned job within the time period mutually agreed upon. Thanx & Regards. Muhammad Ilyas Saeed.
$20 USD in 1 day
5.0 (50 reviews)
5.2
5.2
User Avatar
Hello, I can certainly help you with any excel formula. I am available now, feel free to message me anytime. Thank you -John
$30 USD in 1 day
4.9 (58 reviews)
5.3
5.3
User Avatar
Hello I can create your needed formula exactly as you want it can we discuss? John
$16 USD in 1 day
5.0 (64 reviews)
5.3
5.3
User Avatar
Hi there, Need a custom Excel function that will look up the texts from a table (example sheet2) in a string of text and return the specified value? Please message me if it's ok with you to have the function written in VBA . I can show you a video demo of the text lookup (TLOOKUP) function that is somehow similar to the syntax of VLOOKUP. I'll be standing by to help. -Ige
$25 USD in 1 day
5.0 (33 reviews)
5.2
5.2
User Avatar
Hi there, I am interested in completing your project on creating as excel formula. I have reviewed the file that you have attached and am ready to work on it. Hire me. Thanks in advance.
$20 USD in 1 day
4.8 (38 reviews)
4.8
4.8
User Avatar
Hello, I am proficient in Excel formulas. I have checked the attached spreadsheet and I can surely do it for you. Looking forward for working with you. Regards, Hamid
$25 USD in 7 days
5.0 (17 reviews)
4.3
4.3
User Avatar
Hi I am an expert in Excel and VBA application. I can help you with this task fast and accurate. Contact me to discuss. Regards!
$10 USD in 1 day
5.0 (29 reviews)
4.5
4.5
User Avatar
Hello, I'm an Excel expert with plenty of experience with US clients. Can you message me so that I can solve your problem? This can be done still today! Thanks.
$15 USD in 1 day
5.0 (5 reviews)
3.4
3.4
User Avatar
Greetings, I think here you are looking for someone to create an Excel Formula. I understood your project description. I am an expert in Visual Basic, Excel, and I am interested in your project. I am confident that I can do this with 100% accuracy and ready to start now! But I want to know more about your project. So, can we discuss more? Regards.
$20 USD in 2 days
5.0 (7 reviews)
2.7
2.7
User Avatar
Hi there, I have gone through your project detail and I am much confident to create a formula excel in couple of hours. You will find text strings (located in in Sheet2 Column A) in a cell, and returns the related value in Sheet2 Column B and concatenates them into a single cell in Column G exactly you have mentioned in given sheet. I am expert in Advance MS Excel, Macro & VBA, and have been working on MS Excel for more than five years, two years as local freelancer + three years in a Multinational Company. I'm pleased to have this project and will be completed on time. I have 50 WPM Typing speed with 100% accuracy. Feel free to message me for further discussion. I'm waiting for your positive response. What I am going to do if you hire me: =============================== * High discount on First Project. * Project delivery on time. * Unlimited Revisions before closing project. * Excellent Communication Skills * Support 24*7 Thanks & Regards Azhar Uddin
$12 USD in 1 day
5.0 (4 reviews)
2.0
2.0
User Avatar
Hello, I have been using the excel program for many years. I did a study like this to someone in United States recently. I would like to help you quickly. Waiting for your message.
$10 USD in 1 day
3.5 (2 reviews)
1.6
1.6
User Avatar
Hello. I can help you with your project. I can start right away and send it too you in couple of hours. I hope to hear from you with more details.
$21 USD in 1 day
5.0 (1 review)
1.0
1.0
User Avatar
Hi there! Sir i have read your project description. Sir i am try to fix your requirement. Please give me some time so that i will fix it. Regards Ahmed Awan
$15 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, As a financial engineer working on mathematical algorithms, I can help you create the solution that perfectly meets your needs. Please feel free to contact me for more details. Best regards, Amine
$13 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I read your project carefully and would like to work on it. I am an accountant and I have good experience with excel. Hope to hear from you soon. Best greetings
$20 USD in 7 days
5.0 (1 review)
0.0
0.0
User Avatar
I have excellent skills in excel from 5 years of experience working with excel and its various functions. I can create a formula to get the desired results with a day. Can we discuss further? Natascha
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
San Diego, United States
5.0
8
Payment method verified
Member since Aug 3, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.