Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I find a name in a list of names?
I need to check if certain names from a list are in another list for
comparison. If the names are found in the search I need them to be highlighted or flagged somehow?? Example A B 1Henry, John 1Joe, Joe 2Kitty, Cat 2Chris, Chris 3Henry, John Thanks for your help!!=) |
#2
|
|||
|
|||
Check out
http://cpearson.com/excel/duplicat.htm In article , Cat wrote: I need to check if certain names from a list are in another list for comparison. If the names are found in the search I need them to be highlighted or flagged somehow?? Example A B 1Henry, John 1Joe, Joe 2Kitty, Cat 2Chris, Chris 3Henry, John Thanks for your help!!=) |
#3
|
|||
|
|||
Look in the help menu for VLOOKUP() or MATCH(). This will do what you are
looking for. -- Regards, Dave "Cat" wrote: I need to check if certain names from a list are in another list for comparison. If the names are found in the search I need them to be highlighted or flagged somehow?? Example A B 1Henry, John 1Joe, Joe 2Kitty, Cat 2Chris, Chris 3Henry, John Thanks for your help!!=) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
Find in a list | Excel Discussion (Misc queries) | |||
filter 400 names from list 1 from list 2 with 4000 names | Excel Worksheet Functions | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
cannot find list in excel 2000 | Excel Discussion (Misc queries) |