Comparing data within worksheets
 

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

Comparing data within worksheets
 

Excel Help! -

In cell B2 of worksheet A, put this:

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

In cell C2, put this:

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

Drag these formulas down the columns.

--
Daryl S


"Excel Help!" wrote:

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

Comparing data within worksheets
 

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?


"Daryl S" wrote:

Excel Help! -

In cell B2 of worksheet A, put this:

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

In cell C2, put this:

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

Drag these formulas down the columns.

--
Daryl S


"Excel Help!" wrote:

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

Comparing data within worksheets
 

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?

"Excel Help!" wrote:

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?


"Daryl S" wrote:

Excel Help! -

In cell B2 of worksheet A, put this:

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

In cell C2, put this:

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

Drag these formulas down the columns.

--
Daryl S


"Excel Help!" wrote:

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