=IF(Sheet1!A1&Sheet1!B1=Sheet2!A1&Sheet2!B1,"Yes", "")
can be entered in a separte column to match over two Sheets.
HTH
GK
"Curalice" wrote:
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
--
Curalice
------------------------------------------------------------------------
Curalice's Profile: http://www.excelforum.com/member.php...o&userid=28600
View this thread: http://www.excelforum.com/showthread...hreadid=483254