It seems like a simple VLOOKUP formula should do it

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KenD" wrote in message
...
I have four worksheets. The first one has all members of the group. The
second one lists all people who have home phones and their phone numbers.
List three lists all who have work phones (much smaller list, since all
members don't have work). The fourth lists all people who have cellphones
(also a different list since all don't have cells). What I need is one
final
sheet with a column for each person for home phone, work phone and
cellphone.

How do I combine the sheets to do this?