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
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