I need to lookup and compare names from 3 worksheets: I need worksheet 1 to
search thru worksheet 2 (names(A)) and worksheet 3 (names(A)); if name is
located in worksheet 2 update worksheet 1 (subject1(B)) with "yes"; if not
update with "no"; if name is located on worksheet 3 update worksheet 1
(subject2(C)) with yes; if not update with "no". Names may not be in order
on each worksheet. I appreciate any help. Thanks

(A) (B) (C)
Worksheet 1: Names Subject 1 Subject 2
(A)
Worksheet 2: Names
(A)
Worksheet 3: Names