MS Excel macro to query large CSV file

• Project ID:

  741821

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

We need a simple microsoft excel macro that realizes the following functions.

We have two files:
1. ZIP CODE DATABASE
- Comma split database with zipcode and corresponding street address1,2,3
2. OUR ORDER INVOICE DATA (xls)
- Our store order data with Zip code for delivery address
- No street address data (only ZIP code) from customer

What we need:
We need the so to say Vlookup function that can lookup the ZIP CODE DB using ZIP code as the lookup key, to complete the store order data. the CSV has more that 10K line, thus cannot be opened via xls, so we're looking for a simple macro to realize the "vlookup" function.

The macro should have:
- Flexibility and which columns it uses as input and output
- be automatic so that in one-click, multiple cells in a column can be filled.

Looking for xls experts.
The budget will be less than $100, and lower bids will have advantage as we're hoping the macro is pretty simple.

Thanks everyone!

Additional Project Description:

07/18/2010 at 11:43 EDT:
The actual zipcode db (column 2 zipcode, 3-5 street addresses) and output xls uploaded. For your reference.

Skills required:

Microsoft, Visual Basic

Additional Files:

sample.zip