First off, I'm using Office 97 and am very non-Excel oriented, so please be
patient with me and talk to me like I'm two.

I have a workbook and in this workbook I have several worksheets, two of
which are named Clients and Coordinators.The Clients worksheet contains
normal database info such as name, address, zip etc. The Coordinator
worksheet has the Coordinator's name and zip.

What I need is a column in Clients to match the client's zip with the
Coordinator's zip and enter the name of the matching Coordinator
automatically. The coordinators will change every now and then, if that
matters. The zips shouldn't, but with the government who knows?

So using this as an example:
Clients worksheet column A is client name, column I is the zip code, and
column R is where I want the coordinators name that is looked up on the
Coordinators worksheet. Coordinators worksheet column A is the coordinators
name and column B is the zip code, which should match the Clients worksheet
zip code.

Any help is appreciated in advance. I hope I explained this properly.

Cindy