Matching 2 rows
Posted by Cathy on June 19, 2001 7:09 PM
I have 2 files. One with Customer Code and Sales Volume
the other one with Customer Code, Customer Name and Addresses. I would like to add the Sales Volume to the Second file by matching the Customer code. How can I do this ? Thank you for your help
Posted by Richard S on June 19, 2001 7:42 PM
=VLOOKUP(A3,[Volume.xls]Sheet1!$A$2:$B$3,2)
The above formula is in column D, and assumes column A in the current sheet has the custome code and column A in the Volume.xls file also has the customer code. Just be aware that if the custome code is not in the volume.xls file, the formula will return the previous entry. The volme file must also be sorted in customer code order.
HTH
