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!
Hi
If you want to load all 100k lines of data in the xls file to make maintenance easier, consider using conditional vlookup with more than one table.
I have sucessfully done one with 10 million records with Excel 2007 recently. I consider Excel 2003 can handle 100k records without any deteriating performance please.