Excel Help - Lookup function?

[Betty]

I could really use some help if someone is available and willing...

I've got 2 spreadsheets in excel - although they could be put into one on seperate pages or even on the same page.

One spreadsheet had sales order numbers, names, source of sale and amount of sale.

The other one is a name and address list.

I need to have the first spreadsheet have 2 more columns that use the city and zip code data from the other spreadsheet.

The result would be that I could check the source of each sale and see what city it was from, thereby letting me see which areas a magazine is doing well in and which zones from that magazine are not.

I've tried using the lookup function and can't get it to return the accurate city. I'm assuming the zip code will be easy and just copying the basic idea of the city column.

I would be matching up the two using the name column - which are exactly the same on each spreadsheet - although some customers will have more then one sales order.

If anyone can give me some pointers, I'd really appreciate it.

Thanks.