Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Function or formula needed
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 |
#2
|
|||
|
|||
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? -- Regards, Ron |
#3
|
|||
|
|||
R2: =INDEX(Coordinators!A1:A1000,MATCH(I2,Coordinators !B1:B1000,0))
-- HTH Bob Phillips "CindyH" wrote in message ... 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 |
#4
|
|||
|
|||
Does that help?
Absolutely! Thank you, thank you, thank you! |
#5
|
|||
|
|||
--
HTH It does, thank you so much! Cindy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rate function formula?? | Excel Worksheet Functions | |||
weeknum function says jan1=week1, mod to first 4 day week needed | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Help! Formula needed. | Excel Discussion (Misc queries) |