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

=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

Thanks, I will try that


--
Curalice
------------------------------------------------------------------------
Curalice's Profile: http://www.excelforum.com/member.php...o&userid=28600
View this thread: http://www.excelforum.com/showthread...hreadid=483254