| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Worksheets on Common Column
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining Worksheets on Common Column
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining two ranges based on common a common value | Excel Discussion (Misc queries) | |||
| How to combine two worksheets into one. Only ONE column is common. | Excel Discussion (Misc queries) | |||
| Combining worksheets with common column but different number of ro | Excel Worksheet Functions | |||
| combining excel worksheets with common columns | Excel Discussion (Misc queries) | |||
| Sharing common column data on several worksheets? | Excel Discussion (Misc queries) | |||
Linear Mode
