Check another sheet for full name, return telephone #

Diego Garcia · May 23rd, 2002, 04:35 AM

I have 2 sheets, first is "2001" a database of registered members addresses, second is "Groups" a list of people attending various activities. The activities are supervised by Group leaders who do not know if all those attending are registered. At the start of each term the group leader submits the names of those attending. I then have to check with the 2001 sheet that each member is registered. For other admin purposes I list the Groups and attendees in "Groups" with their Tel #. By entering the Surname and First name in "Groups" can I get it to return the Tel # from "2001" ?
Relevant columns are:
2001
Col A Surname (ascending order)
Col B First name
Col H Tel #

Groups
Col A Group name (ascending order)
Col C Surname (ascending order in that group)
Col D First name
Col E Tel #

crimlet · May 23rd, 2002, 04:46 AM

Before a reply is possible I need a little more information. How many members do you have to look for. Problems I could imagine happening are people with the same names e.g. John Smith what happens here ? The solution if there are not duplicate names is quite simple. I would cancatenate the names on your base data giving a cell with "First name , Last Name" then i would use =vlookup to search for the phone numbers. If you could reply to my question I will then give you a better formula

Diego Garcia · May 23rd, 2002, 05:07 AM

There are 178 members. Quite a number of people have the same surname (Evans, Davies, Jones, Williams) and where husband & wife join they have seperate entries.

crimlet · May 23rd, 2002, 07:07 AM

Quote:

On 2002-05-23 04:07, Diego Garcia wrote:
There are 178 members. Quite a number of people have the same surname (Evans, Davies, Jones, Williams) and where husband & wife join they have seperate entries.

Could you send me the sheets so I can write the formulas jason.marter@bt.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 04:35 AM	#1
Diego Garcia New Member Join Date: May 2002 Location: Rhos On Sea, Wales Posts: 23	I have 2 sheets, first is "2001" a database of registered members addresses, second is "Groups" a list of people attending various activities. The activities are supervised by Group leaders who do not know if all those attending are registered. At the start of each term the group leader submits the names of those attending. I then have to check with the 2001 sheet that each member is registered. For other admin purposes I list the Groups and attendees in "Groups" with their Tel #. By entering the Surname and First name in "Groups" can I get it to return the Tel # from "2001" ? Relevant columns are: 2001 Col A Surname (ascending order) Col B First name Col H Tel # Groups Col A Group name (ascending order) Col C Surname (ascending order in that group) Col D First name Col E Tel #

May 23rd, 2002, 04:46 AM	#2
crimlet Board Regular Join Date: May 2002 Location: Ipswich, Suffolk, England Posts: 135	Before a reply is possible I need a little more information. How many members do you have to look for. Problems I could imagine happening are people with the same names e.g. John Smith what happens here ? The solution if there are not duplicate names is quite simple. I would cancatenate the names on your base data giving a cell with "First name , Last Name" then i would use =vlookup to search for the phone numbers. If you could reply to my question I will then give you a better formula

May 23rd, 2002, 05:07 AM	#3
Diego Garcia New Member Join Date: May 2002 Location: Rhos On Sea, Wales Posts: 23	There are 178 members. Quite a number of people have the same surname (Evans, Davies, Jones, Williams) and where husband & wife join they have seperate entries.