I have 2 work sheets with 20 colums and 2000 rows
My example may discribes as like this in both the sheets

doc no doc type amt

Here i require a formula which checks up both doc no and amount in both the
sheets, if it matches should display as "Matched" or "Not Matched"

Thank you guys for taking much pain in resolving this

Hi,

Hope you understand the answer:-

I have just done 1 field you should be able to check it and modify it for
the 2nd.

Test case is as follows:-

Sheet1 = doc no doc type amt (Columns A to C)

Sheet2 = doc no doc type amt (Columns A to C)

in column D formula is =IF(Sheet1!A2=Sheet2!A2,"Matched","Not Matched")

if you copy formular down all 2000 rows it shoud work.

If you want the same for sheet 1 just apply to column D

If you want to highlight it you could use conditional formatting and make
background red if d = Not Matched

Hope you can understand

Trev



"vijaydsk1970" wrote:

I have 2 work sheets with 20 colums and 2000 rows
My example may discribes as like this in both the sheets

doc no doc type amt

Here i require a formula which checks up both doc no and amount in both the
sheets, if it matches should display as "Matched" or "Not Matched"

Thank you guys for taking much pain in resolving this

Dear Trever,
Thank you very much for your advice.
But my data in the two sheets is not sorted. The formula has to check from
top to bottom and should display "matched" or "not matched"

"Trever B" wrote:

Hi,

Hope you understand the answer:-

I have just done 1 field you should be able to check it and modify it for
the 2nd.

Test case is as follows:-

Sheet1 = doc no doc type amt (Columns A to C)

Sheet2 = doc no doc type amt (Columns A to C)

in column D formula is =IF(Sheet1!A2=Sheet2!A2,"Matched","Not Matched")

if you copy formular down all 2000 rows it shoud work.

If you want the same for sheet 1 just apply to column D

If you want to highlight it you could use conditional formatting and make
background red if d = Not Matched

Hope you can understand

Trev



"vijaydsk1970" wrote:

I have 2 work sheets with 20 colums and 2000 rows
My example may discribes as like this in both the sheets

doc no doc type amt

Here i require a formula which checks up both doc no and amount in both the
sheets, if it matches should display as "Matched" or "Not Matched"

Thank you guys for taking much pain in resolving this