Excel - VLookup - Cleanup

$8-15 USD / hour

Imekamilika

Imechapishwa

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.

Kitambulisho cha mradi: 32796537

Kuhusu mradi

20 mapendekezo

Mradi wa mbali

Inatumika 2 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@AnowarRatul

$0 USD ndani ya siku 40

5.0

(366 hakiki)

6.7

20 wafanyakazi huru wana zabuni kwa wastani $12 USD/saa kwa kazi hii

@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 ndani ya siku 20

4.9

(219 hakiki)

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 ndani ya siku 40

4.8

(85 hakiki)

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 ndani ya siku 40

5.0

(57 hakiki)

5.5

@PERPETUAL0

Hello there its not take more than hour regard s ILYAS

$12 USD ndani ya siku 40

4.8

(96 hakiki)

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 ndani ya siku 40

4.9

(35 hakiki)

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 ndani ya siku 40

4.9

(34 hakiki)

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 ndani ya siku 40

5.0

(10 hakiki)

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 ndani ya siku 40

5.0

(7 hakiki)

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 ndani ya siku 40

5.0

(2 hakiki)

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 ndani ya siku 40

5.0

(1 hakiki)

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 ndani ya siku 40

0.0

(0 hakiki)

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 ndani ya siku 40

0.0

(0 hakiki)

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 ndani ya siku 40

0.0

(0 hakiki)

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 ndani ya siku 2