| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I check names in one list agains names in another in excel?
I have a list of names in one column, andanother list of name in a separate
column. How do I cross-reference the names with eachother. What I want to do is find out if a name in one column is repeated in the other. Is tis possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I check names in one list agains names in another in excel?
Use VLOOKUP function
Syntax VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup) Ex: = VLOOKUP("DI-328", A2:D6, 3, FALSE) "John@Hospice of Hope" wrote: I have a list of names in one column, andanother list of name in a separate column. How do I cross-reference the names with eachother. What I want to do is find out if a name in one column is repeated in the other. Is tis possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check a list of numbers for duplicate entries in Excel | Excel Discussion (Misc queries) | |||
| auto updating list | Excel Worksheet Functions | |||
| Check 2 different list get associated value from a column | Excel Worksheet Functions | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
| How do I put a list of names and e-mail addresses in excel so tha. | Excel Discussion (Misc queries) | |||
Linear Mode
