| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copying information
When working on a list of names in column A Excell will automatically pap the
name up if I start to enter it again on a different line, but how do I get excel to also copy the information for that person in cells in column B & C? example: A B C Name ID# Phone# smith, jo 231 9999999 If I type smith, jo again on the list only smith, jo appears I need for the other to colums to also appear. -- Thank you for your help, Taz |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
copying information
Use VLOOKUP
-- Gary''s Student "Taz" wrote: When working on a list of names in column A Excell will automatically pap the name up if I start to enter it again on a different line, but how do I get excel to also copy the information for that person in cells in column B & C? example: A B C Name ID# Phone# smith, jo 231 9999999 If I type smith, jo again on the list only smith, jo appears I need for the other to colums to also appear. -- Thank you for your help, Taz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing information from 2 workbooks into a 3rd one | Links and Linking in Excel | |||
| Importing information from 2 workbooks into a 3rd one | Excel Worksheet Functions | |||
| Importing information from 2 workbooks into a 3rd one | Excel Discussion (Misc queries) | |||
| Comparing and copying information from one cell to another | Excel Worksheet Functions | |||
| Illinois Personal Information Protection Act | Excel Worksheet Functions | |||
Linear Mode
