Formula for searching names in one go

SilverChat

New member
Joined
Feb 28, 2015
Messages
7
Reaction score
0
Points
0
Excel Version(s)
2016
Please help me out ...
here I am attaching snapshots of two excel sheets
1. has description
2. names of persons


What I wanna do is that , I want to check the names of person are matching should indicate me in red or whatever color in different cell from description list. If name is already in the list of "names list" file matching from the list of "names description" file should show me the indication that name is already in the list.
Thanks waiting for snappy response.
7eHqNO1.png

8p1I61R.png
 
Please attach a sample copy(with names changed, if confidential). Or provide NAMES LIST and NAMES DESCRIPTION of same person so that I can relate what exactly you require. I think this can be done with conditional formatting and countif function.
 
Back
Top