Excel - VLookup - Cleanup

$8-15 USD / hour

Завершено

Опублікований

over 2 years ago

$8-15 USD / hour

I have two Excel sheets. I am using the company name field from both sheets to match using VLookup and populate an ID field. Most matching is done but there are differences in some company names which effect the accuracy. I need this cleaned up so all possible matching is complete. This means normalizing the company names on both sheets so they match exactly. There will be duplicate names occasionally and the most complete name will survive the edit process and be matched. Please provide a cost and delivery estimate in your response.

ID проекту: 32796537

Про проект

20 пропозицій(-ї)

Дистанційний проект

Активність 2 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@AnowarRatul

$0 USD за 40 дні(-в)

5,0

(366 відгуки(-ів))

6,7

20 фрілансерів(-и) готові виконати цю роботу у середньому за $12 USD/год.

@uumarkhalid31

Hi I am expert in excel and i have full command on vlookup or normalizing the data. contact me and lets discuss the job with perfection and accuracy regards Umar

$12 USD за 20 дні(-в)

4,9

(219 відгуки(-ів))

7,0

@charleslimnet

Hello I am a proficient EXCEL VLOOKUP expert in business and finance analysis. I have 18 years’ experience as a practicing CPA and 20 years’ experience as an academic researcher and analyst. I am passionate about this project having gone through the instructions. I have 520+ reviews on related projects and the responses are positively overwhelming. I hold an MBA (Strategic Management), Bachelors of Commerce (Finance and Accounting) & C.P.A. (Certified Public Accountant.) Regards, Charles.

$15 USD за 40 дні(-в)

4,8

(85 відгуки(-ів))

6,3

@konanhenry1111

2 hours = 50$ ⭐⭐⭐⭐⭐⭐I am an engineer and I read the details accurately.⭐⭐⭐⭐⭐⭐ I am ready to start now. Just if u have more details or questions u can ask me in chat. Check my projects that I have finished related to engineering in my profile. Let us discuss in chat. "

$12 USD за 40 дні(-в)

5,0

(57 відгуки(-ів))

5,5

@PERPETUAL0

Hello there its not take more than hour regard s ILYAS

$12 USD за 40 дні(-в)

4,8

(96 відгуки(-ів))

5,4

@utkarsh7238

Hello, I can clean up your 2 Excel sheets with VLookup In how much time you want it to be completed? Let's talk about your Project Waiting for your Response!!

$8 USD за 40 дні(-в)

4,9

(35 відгуки(-ів))

4,8

@Peefect

Hi, After checking file I have found I can do it with in 20 to 30 min only . Thanks.(Note-I am an expert and I am waiting please reply fast)

$8 USD за 40 дні(-в)

4,9

(34 відгуки(-ів))

4,3

@MamukaB

Good Morning I'm doing reports using excel VBA from big data bases So, it's easy job for me. I think I can do the project , but need some more detailed clarifications from you I have 15+ year experience with Excel VBA So you can trust to me. Result will be excellent Thanks

$8 USD за 40 дні(-в)

5,0

(10 відгуки(-ів))

3,5

@rahulg5466

--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v lookup, word, excel database, and Microsoft office at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let's discuss more in the chatbox. Regards Rahul

$12 USD за 40 дні(-в)

5,0

(7 відгуки(-ів))

2,6

@kamranbashir2020

Hi! I am a data entry expert . I am ready to start right away. Let's talk over the chat to discuss further. Thank you!

$9 USD за 40 дні(-в)

5,0

(2 відгуки(-ів))

1,8

@tefoai

Hi, could you please give an example? Like for example you have rows like McKinsey and Mc-Kinsey, which are same but in terms of letters they are not. And you want me to fix all of these, right? If so, I can do it for 40$ in whole dataset.

$8 USD за 40 дні(-в)

5,0

(1 відгук)

1,3

@payalku40

HhI I can start right now but i have few doubts and questions lets have a quick chat and get it started waiting for your replyyy

$12 USD за 40 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@gracew20

Hello, I am Grace ,your data analyst professional in the following areas, with 4 years experience ≥macros ≥VBA ≥pivot tables ,power query,charts and dashboards with slicers and timeline ≥Automation of sheets with formulas ≥Data filtering, sorting, vlookups and data validation ≥statistical data analysis in excel ≥Consolidation of excel reports

$12 USD за 40 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@Roshan876

I can arrange all your missed placed names on your sheet, on time and accurate. You won’t have anymore problems with the accuracy of your work.

$13 USD за 40 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@MuhammadAdil17

Hello dear, Hope you are doing well Please contact that i can help you in in this issue you will not get any inaccuracy after i assist you I can do it in a few minutes. I am at your service please contact. Thanks

$10 USD за 2 дні(-в)