Function or formula needed

C

CindyH

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
 
R

Ron Coderre

Assuming you have column headings in row1, put this formula in cell R2 on the
Clients sheet and copy down:

=INDEX(Coordinators!$A$1:$A$1000,MATCH(Clients!$I2,Coordinators!$B$1:$B$1000,0),1)

That formula should find the zipcode on the Coordinator sheet that matches
the Client zipcode and return the Coordinator name.

If 1000 rows is not enough, adjust the ranges to suit your situation.

Does that help?
 
Top