HELP!!!! VLOOKUP?
Posted by Dan Cammack on July 13, 2001 2:07 PM
I have a problem... I need to merge two sets of information on two seperate excel sheets into one... the one constant that I have is a customer # that refers to information contained in that row and this is constant in both spreadsheets. I.e. I have 2000 cusotmers in one spreadsheet and 1000 in another. One has ship-to addresses with the corresponding customer # one has the contact with the corresponding customer #... how do I import or write a formula to search on or the other databases for matching customer #'s and when it finds a match, copy or paste information from a third cell into the designated cell on that row...???? HELP PLEASE!!!! DAN @ awri1@aol.com
Posted by lenze on July 13, 2001 2:13 PM
Oe way is use MS Query to create a rational database. See the below link for an excellent example:
http://tushar-mehta.com/excel/newsgroups.rdbms_in_excel/intro.html
Posted by Russell on July 13, 2001 5:14 PM
Dan,
Check this posting and see if it helps:
