Data Analysis

[ghadir14]

Hello ,
I have a workbook e.g. A.

I have another workbook ..B.

A is continuously updated...ie figures in cell references.

This updated figures are then changed on the same cell references in worksheet B, so in effect B then becomes a mirror of A including the totals for each row and column.

How can i check the data in each column is reflected correctly in each column of B, since there are over 2000 rows...

i remember seeing a formula starting with =chk but don't know the rest of the parameters...

I guess i would need to lable the column to the right of the data with the word check....(yes /no??) but can't seem to find this in text books but I know it exists..

Can someone help me.....surely I can't keep scrolling up and down each of the sheets that many rows....

In addition How can I lookup and compare the data to check,,,,i presume it should be =iflookup....

Also what does '' '' mean in lookup?

[corinereyes]

Hi ghadir14,

Can you attach a simple example of a xl file so others can clearly understand your query.

[Mark@Work]

Assume list A is in Cells A1 to A600, list B is in B1 to B600
Type the following into a conveinent empty cell:
=IF(AND((A1:A600)=(B1:B600)),"OK","Error")
press Ctrl Shift Enter (i.e the Ctrl key and the Shift Key and the Enter key all at the same time).

This tells EXCEL that this is an "array formula" thus it works out as:
=IF(AND((A1=B1),(A2=B2),...,(A600=B600)),"OK","Error")

Mark.