Compare 2 column list across 2 sheets

Gerry,

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

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

Knightly

GerryK Wrote:
> 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


--
sirknightly

Gerry,

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

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

Knightly

GerryK Wrote:
> 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


--
sirknightly

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

Gerry,

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

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

Knightly

GerryK Wrote:
> 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


--
sirknightly

Gerry,

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

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

Knightly

GerryK Wrote:
> 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


--
sirknightly

Gerry,

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

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

Knightly

GerryK Wrote:
> 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


--
sirknightly