Combine 2 Excel files using Excel Script / Macro / Lookups

This project was successfully completed by kahartle for $30 AUD in 2 days.

Get free quotes for a project like this
Project Budget
$10 - $30 AUD
Completed In
2 days
Total Bids
Project Description

Create a Excel Macro, or script to combine 2 sheets of data into 1 final spreadsheet in the attached "Final" format.

Lookup the "ArtNr" from [[url removed, login to view]] output the "Ztype" and "Note" if it is found in [[url removed, login to view]]. Please note of all the spacing and breaks in the [url removed, login to view] file.

I have used colours to help understand the relationships, but this is not required in the final output.


[url removed, login to view]

[url removed, login to view]


[url removed, login to view]

This needs to be created in a way that I can run the script many times in the future and handle large volume of data. (100,000+ records)

Completed by:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online