Finding duplicates

[mhakwatut]

Hi Folks!
The details, Excel 2007, 10MB shared workbook with 15 sheets, users across multiple states. Most sheets have very large arrays, ~1500 rows/records with 30 to 50 columns.
The help needed, as part of a weekly project, to identify cells on each sheet that have changed and to mark them for evaluation, based on the prior weeks report.

I've been trying to get an INDEX, MATCH along with an IF statement to work and have been unsuccessful. If I use IF(sheet1!F3=master!F3,"",1) , that puts a 1 in the column I'm using to mark changed data for evauation, but I can't seem to get the INDEX MATCH figured out to insure the correct row on each sheet is being compared.

I've looked some commercial products, but each seems to have various limitations, so I thought I'd build what I needed but seem to have hit a wall.

Any suggestions

 

[mhakwatut]

Found my answer in this formula =IF(INDEX('master'!$D$11:$Z$2000,MATCH(D11,'master'!$D$11:$D$2000,FALSE),2)=E11,"ok","evaluate") to compare the master to the information being evaluated and a macro to paste in the various colums.

Thanks to all who viewed!