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!!=)

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!!=)

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!!=)