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