checking two lots of data for any differences

Hi,

I need to make sure that the two sets of data i have highlighted in yellow and blue are completely the same. Please can some one write a formula that will flag a cell next to the blue column indicating that there is a difference between that of the blue and the yellow columns individual row.

Please see the attached

Thanks

Sam

One way:

F1: =REPT("Difference",VLOOKUP(D1,A:B,2,0)<>E1)
copied down

or if the rows correlate at all times (ie Ax=Dx) then

F1: =REPT("Difference",B1<>E1)
copied down
(ie remove VLOOKUP element)

Put this formula in F1 and copy down, or C1 if you want it in the middle. It will give you TRUE/FALSE for matches/misses.

=A1&B1=D1&E1