Excel 2003

S

simplicity girl

I Have 2 excel worksheets. One has a list of customers based on what they
purchased and the other is there name, address, and phone number. Is there
any way (other than to sit and manually match up customer to address) to put
the customer address next to the name. Keeping in mind that they are not all
in the same order, and not all customers are on both lists.
 
B

Bob I

If you sort them each alphabetically you will reduce the amount of side
to side comparison you have to do.
 
D

Dian D. Chapman, MVP

See this article...

Excel’s VLOOKUP Function: How to Use It and How to Nest It
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=446

Dian D. Chapman
Technical Consultant, Microsoft MVP
MOS Certified, Editor/TechTrax

Free MS Tutorials: http://www.mousetrax.com/techtrax
Free Word eBook: http://www.mousetrax.com/books.html
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html


On Thu, 15 Feb 2007 13:10:40 -0800, simplicity girl <simplicity
 
Top