MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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:

If not, post another message....

Hope this helps,

Russell