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.
The actual zipcode db (column 2 zipcode, 3-5 street addresses) and output xls uploaded. For your reference.