In Progress

Match Columns in Excel and return values from one sheet to another

2 sheets in workbook named all_records.

Sheet 1 – All Records

Sheet2 – Some Records.

Task

Clean up phone number field. (remove the clearly bogus and format to 7 digit number)

Leave Duplicate records

1. Match Column G on “some records” sheet to (cleaned up column M on All records) If there is a match return corresponding value for column I on “some records sheet” to column N on all records sheet.

2. Match Column G on “some records” sheet to (column E on All records) If there is a match return corresponding value for column I on “some records sheet” to column O on all records sheet.

Save it and send it back.

Skills: Excel

See more: m format in excel, save to excel, Return, match, excel duplicate, another back, excel digit, match records, excel duplicate values, match columns excel, excel phone records, excel column column, excel match columns, phone number excel, phone number records, excel phone number, excel sheet phone, excel sheet phone number, clean sheet excel, phone number excel sheet, clean format excel, phone number sheet, columns, sheet columns, clean excel sheet

About the Employer:
( 2 reviews ) Austin, United States

Project ID: #2535740

Awarded to:

Engineer85

Hi I am an Engineer and Excel professional and can handle this job. Please check PM. Thanks

$36 USD in 1 day
(10 Reviews)
4.2

6 freelancers are bidding on average $39 for this job

bouslimi1979

Please check PM. Thanks

$50 USD in 1 day
(31 Reviews)
5.3
mrbrave

Hi....Get it done in 1-2 hours...

$30 USD in 0 days
(64 Reviews)
5.3
HardWorker1989

Hello Sir. I am a highly qualified and certified MS Office, Adobe Acrobat, Adobe Photoshop and Adobe Illustrator professional designer and developer. I can do the tasks that will be provided in an efficient, quic More

$45 USD in 2 days
(14 Reviews)
4.7
bubyco

i'm ready for this

$30 USD in 2 days
(1 Review)
1.6
jazzdoit4real

hi I am from Philippines and I think I can do this job for you for full time as of now, because I don't have work. I have my own internet connection and I owned a laptop for me to do this job for you.

$40 USD in 1 day
(0 Reviews)
0.0