Here's my challenge. I have two excel lists with different data fields (column headings). Both lists have one common column (a store number - however with different numbers of rows). Is there a way to merge the two lists into a third list, and combine all the data using the common column (store number)? Ie, append the information so that it reads across.

Also, are there any good web resources or books that would help me? I have the Missing Manual book, but this topic isn't really covered.

using Excel v.X, on Tiger, if it matters.

Yes, this can be done. Here are the best sites on the web for solving XL problems. World class Excel experts run the boards and frequent the boards. They are very responsive, sometimes within minutes. And you will learn Excel. Also, check out (search) all the other material besides the forums - there is a ton of info. This issue has already been addressed in them, so you might just do a search and get what you need.

MrExcel.com

Ozgrid

VBA Express