Compare excel tables, look up & report common values

Compare 2 excel tables (A & B) using vlookup formula/pivot tables or other to identify & isolate common values in a specific column in the two tables (i.e. Policy Number X found in table A is also found in table B) and exhibit the relevant value appearing in each table (i.e. Premium of X in A & Premium of X in B).

Skills: Data Entry, Data Processing, Excel, Microsoft Office, Visual Basic

See more: compare excel sheets, compare excel files, code compare excel files, excel, code compare excel files find similar items, code compare excel sheets, code compare excel file, code compare excel files aspnet, excel vba look data sheet, program compare excel files, convert word tables excel tables, compare excel, compare excel documents, compare excel tables, compare excel files using, compare excel sheets using net, compare excel files using net, compare excel sheets generate report based common fields, identify common cells columns excel, compare excel files vlookup

About the Employer:
( 7 reviews ) Halandri, Greece

Project ID: #16303192

Awarded to:


Dear client I have previously carried out a number of projects in excel using macros and formulas. Regarding this project I believe it can be done using formulas. I understand completely what is needed in the project. More

€20 EUR in 1 day
(258 Reviews)

49 freelancers are bidding on average €25 for this job

€30 EUR in 1 day
(239 Reviews)

Dear Sir/Madam, Thank you for reading my proposal. I am expert in Admin support, Customer support, eCommerce product listing, Online Marketing and Web Development services . I have following experience of work wh More

€24 EUR in 1 day
(37 Reviews)
€30 EUR in 1 day
(186 Reviews)

Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in ge More

€55 EUR in 1 day
(106 Reviews)

Hello sir I can start the project right now Kindly contact me through personal message Thank You

€26 EUR in 1 day
(58 Reviews)

Greeting, I have understood your Compare excel tables, look up & report common values task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in More

€35 EUR in 1 day
(14 Reviews)

I can write a macro to output the values of premium for the same policy number in the two files. some policy numbers in the first file are not found on the second file; these will show only one value

€14 EUR in 1 day
(62 Reviews)

I am 9+ Years of Experienced Software Developer, successfully completed many projects (please see my reviews), like to work on your project. ASP.Net, C#, VB.Net, MVC, WPF, Visual Basic, Excel VBA, MS SQL Server, MYS More

€50 EUR in 1 day
(27 Reviews)
€34 EUR in 3 days
(23 Reviews)

I am a professional with years of experience working in a US based NASDAQ registered company's finance department with an excellent excel knowledge

€12 EUR in 1 day
(35 Reviews)

Hi I am Good in excel and vlookup specially. I have done similar kind of job earlier. I can do this immediately. Thanks.

€8 EUR in 1 day
(40 Reviews)

Hello I am a highly skilled data processor can you share more information over chat Thank you in advance

€23 EUR in 1 day
(23 Reviews)

Hi Dear Client. I am expert Data Miner and Web developer. I have experienced with data mining and site crawling and automatics uploading. I can complete your job quickly and perfectly. Thanks for your time.

€88 EUR in 1 day
(3 Reviews)

My key skills are relevant to this project. I have huge experience in this area. I can do this project very efficiently.

€8 EUR in 0 days
(30 Reviews)

Sounds no big deal. I'm an MS Excel expert, and use the lookup function very frequent. Drop me a message and let me help you.

€20 EUR in 1 day
(5 Reviews)

Hi This can most certainly be done in less than an hour. In fact, I will work on it now and have it ready for you by the time you send me a message. Kind regards John

€8 EUR in 1 day
(14 Reviews)

Hi there: By viewing the project, i am offering my services. i am expert in Excel and accountant by profession having 10 years working experience in Ms-Excel. By completely understanding the project, i will: a. More

€19 EUR in 1 day
(4 Reviews)

hi there, your work is ready. if you think my bid is appropriate you can award the project to me and I'll attach document and send it to you. you can then release the payment if the work seems appropriate to you. More

€27 EUR in 1 day
(4 Reviews)
€12 EUR in 1 day
(2 Reviews)

I can do it for you easily. I am using ActiveData for excel which is a powerful tool that let me merge & identify the duplicates instantly. Please don't hesitate to contact me for any further clarification.

€14 EUR in 1 day
(4 Reviews)