Help matching entries in two sheets???

C

Curalice

Help with Lookup Formula
What I want to do:

From entries in List A, column 1 and Column 2,
Find matches in List B, column 1 and Column 2,
If found, return text (“yes”) in another Column of List 1 (same row as
match) and another Column of List 2 (same row as match).

Example: Both lists contain Jane (Column 1) and Doe (Column 2). The
idea is to match them and check them off in another column.

Thanks.

I use Windows XP2, Excel 2000
 
G

GerryK

=IF(Sheet1!A1&Sheet1!B1=Sheet2!A1&Sheet2!B1,"Yes","")
can be entered in a separte column to match over two Sheets.

HTH
GK
 
Top