On Sheet 1 I have names of people in cells B2 through O2.
On Sheet 2 I have a lookup list of names.
On Sheet 1 cell P2 I'd like to do an If/index/match formula that looks ad B2-O2 to see if any of the names in my lookup list are in any of those cells. If they are it will return "Yes". Even...