finding specific data

Hi everyone,
first of all let me apologise if this is in the wrong section!
i am new to this site so am still finding my way around!

ok so basically what i've got is two spreadsheets pulled from different servers with the same data on it but in a different order.
for example column a on spreadsheet 1 is actually column c on spreadsheet 2.

i need to validate the data on the two spreadsheets to make sure its the same!
so far i've arranged all the data into the correct column's but now i need to view each specific row of data to check that the data is consistent.

i have a column called "issue number" which is unique to each row of data,
is there a way that i can group these to validate the two sets of data?

hopefully i've made my intentions clear for you!

thanks in advance
Steve

Not too difficult. Make sure the "Issue Number" is the first column in both spreadsheets. In your example, then, the data is shifted over one column to make room for the key, and now we need to compare data in column b in the first dataset with column d in the second. Create a new tab with the "Issue Number" as the first column, and a column with the formula like:

if(vlookup([Issue Number]), DataSet1,2,0) = vlookup([Issue Number]), DataSet2,4,0), "","No Match").

Create a separate check column for each data item you want to compare.

Hope this helps

SAE

Perfect thank you!