MrExcel Publishing
Your One Stop for Excel Tips & Solutions


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 @

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:

Posted by Russell on July 13, 2001 5:14 PM


Check this posting and see if it helps:

If not, post another message....

Hope this helps,