Excel List Matching/Lookup

Tamamlanmış İlan edilme: 7 yıl önce Teslim sırasında ödenir
Tamamlanmış Teslim sırasında ödenir

Hello,

In the excel work book there are two sheets.

Working File

Clean Data Base

On the sheet working File I need to populate columns K-R from the Clean Database sheet.

Hidden columns on Working file sheet can't be broken.

To match you can use store number, Address etc. Don't just use Postal code (tried that and it was a fail :(

Looking for ASAP

Veri Girişi Veri İşleme Excel

Proje NO: #11295940

Proje hakkında

27 teklif Uzak proje Aktif 7 yıl önce

Seçilen:

jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% CAD
(324 Değerlendirme)
7.4

Bu iş için 27 freelancer ortalamada $70 teklif veriyor

FINGERRPRINT

i have gone through your file. we are ready to process. we can send you the sample data. But working file itself has a duplicate data. whether we need to delete the duplicate data in working file. eg. FOODLAND (SCH Daha Fazla

$105 CAD in 2 gün içinde
(256 Değerlendirme)
7.7
nikhil08

Hi, we have to do manually using store numbers or using address. I will complete project within 3 days. We will get clear data for max 2582 stores right?

$150 CAD in 3 gün içinde
(136 Değerlendirme)
7.1
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(200 Değerlendirme)
6.7
Marie1234

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(145 Değerlendirme)
6.8
hdlong66

Hello, I've matched 2111 rows of total 4171 rows. I can deliver this part of work if you wish it. Best regards, Hoang

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(87 Değerlendirme)
6.5
pakee

Consider its DONE within 24 HOURS.. EXCEL Expert USER Here.. I can Match/Lookup data from 2 sheets very FAST as i have did such work before.. Lets start.. Ready to START IMMEDIATELY

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(146 Değerlendirme)
6.2
LancerboyAshrak

Hello, I have done similar projects before, I am sure I can do a perfect job for you. 100% accuracy. I really enjoy my work and I am very determined. I hope you will consider my bid. Thank you, Ashrak

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(31 Değerlendirme)
5.5
rohitpithisaria

Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(68 Değerlendirme)
5.7
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further detail Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(108 Değerlendirme)
5.4
nazmulcb

I am very professional data entry and web researcher on freelancer.com. Here I completed a lot of project with good reputation. Very motivated, honest and hard worker. This is my main profession. So I take this serious Daha Fazla

$100 CAD in 5 gün içinde
(55 Değerlendirme)
5.5
Imranatmoon

hello There, Could you please attach excel file here to start cracking. Available and ready to start immediately Best Regards Imran

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(37 Değerlendirme)
5.0
rashaw

Hi, I have checked the excel file and I also can view the hidden column A-D. Hidden column contains: Unique Record Count UniqueID Distributor Sales I can do this job with high accuracy and on budget. Need to d Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(49 Değerlendirme)
5.1
Nidhijain123

Hello, I can take up this task and will ensure the task is delivered as desired and with highest quality. I have sound working knowledge on MS excel. Have understood completely what has to be done and have done one Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(38 Değerlendirme)
4.9
alvichinolan

Hello, Good day! I can complete the project within your specified deadline. You are rest assured of the quality of my work. You can check my profile for review. Thank you.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(42 Değerlendirme)
5.0
skipdavetrans

I will have this done in few hours and delivered back. Well versed with VLookup. Ready to start now.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(27 Değerlendirme)
4.3
wissamSabry

I am an advanced user with over 10 years of MS Excel experience. As A Microsoft Certified System Administrator I am Excellent in word editing, processing , spread sheets I can very quickly help you with any Microsoft E Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(16 Değerlendirme)
3.8
Guruchandar

I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed projects like this. I have excellent command over English. I am a hard wor Daha Fazla

$32 CAD in 3 gün içinde
(10 Değerlendirme)
3.7
satishtl

Matching the store from cleandatabase using the zipcode and city with distributor name seem to solve this. I can do this in next few hours... Have very good expertise in data merging, validation and consolidation. C Daha Fazla

$40 CAD in 0 gün içinde
(12 Değerlendirme)
3.1
valeriy82

I am full time freelancer, working from home. Specialized for any kind of research and virtual assistant tasks. I am a newbie at this site and ready to work hard to build up my reputation.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(11 Değerlendirme)
2.8
fb577926aeb280b

Hello, My name is Olga, I'm from Ukraine. I understood what i need to do on your project, and am ready to start immediately. I focused on high-quality work. I am really interested in your project! Also the work with n Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(2 Değerlendirme)
2.5