Compare 2 column list across 2 sheets

G

GerryK

I cannot get this formula to work:
In E2 Sheet2 I have:
=IF(COUNTIF($A$2:$B$721,Sheet1!A2:B721)+COUNTIF($E$1:E1,Sheet1!A2:B721)=0,"Entered","")

On Sheet2 I'd like to check for data from Sheet1 and place "entered" in
column E.
This formula gives me "entered" all the way down. Sheet2 has data in it that
is exact from Sheet1 plus new data.

Can someone please advise?

TIA
 
S

sirknightly

Gerry,

If I'm understanding correctly, you're trying to compare two columns o
data on one sheet with two columns of data on a separate sheet an
having Excel return "Entered" when Sheet 2 columns match Sheet
columns. If that's the case, try this formula in Sheet2!C2 and drag i
down:

=IF(Sheet1!A2&Sheet1!B2=Sheet2!A2&Sheet2!B2,"Entered","")

Knightly
 
Top