Comparing data within worksheets

  • Thread starter Thread starter Excel Help!
  • Start date Start date
E

Excel Help!

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
 
Excel Help! -

In cell B2 of worksheet A, put this:

=IF(ISNA(VLOOKUP(A2,Sheet2!A2:A7,1,FALSE)),"no","yes")

In cell C2, put this:

=IF(ISNA(VLOOKUP(A2,Sheet3!A2:A7,1,FALSE)),"no","yes")

Drag these formulas down the columns.
 
I only get all "yes" in both B and C. Will this look thru the entire row of
"A" on sheet's 2 and 3?
 
Here's what I entered to work:
=IF(ISNA(VLOOKUP(A2,Sheet2!$A$2:$A$208,1,FALSE)),"no","yes"). I had to enter
the last row and the "$". Not sure this will work on my try?
 
Back
Top