How to compare 2 lists (original and sorted) to verify correct sort

Hello to all,
I have an original list like this: list1.xlsx

NAME CODE CASH
Mike 6001 $15
Anna 3405 $6
Jim 4582
Mary 8482 $7
John 2567
Tom 7234 $2

and after I remove the rows with blank CASH cells and I sort by CODE I get this and save as: list2.xlsx

NAME CODE CASH
Anna 3405 $6
Mike 6001 $15
Tom 7234 $2
Mary 8482 $7

Now, how can I auto-check if NAME has the right CODE NUMER and CASH next to it?
How can I compare list1.xlsx and list2.xlsx and be sure that Mike has next to him 6001 and 15, then Tom etc etc so that I am sure that I haven't screwed up things by a mistaken edit?

Hi and welcome to the forum

If you tried to upload your files, it didnt work

But based on the sample you provided, I created 2 worksheets in the same file, and then used this to compare sheet2 (List2) against sheet1 (list1)....

=AND(VLOOKUP(A2,Sheet1!$A$2:$C$7,2,0)=Sheet2!B2,VLOOKUP(A2,Sheet1!$A$2:$C$7,3,0)=Sheet2!C2)
copied down

If the original list of data starts on Sheet1 A1 with the headers and actual data starting in A2 to C7 and your finished data is on sheet2 starting in A1 with the headers in row 1 and the data from A2:C5, enter this formula in E2 and copy down to row 5 and across to column F.

Formula:

Please Login or Register  to view this content.

In Column G2 of Sheet2 enter this:

Formula:

Please Login or Register  to view this content.

Thank you both. FDibbins you are right. It alignment looked ok in the editor but got messed up when I posted.
Here as some questions (I am a total beginner)

Originally Posted by FDibbins

Hi and welcome to the forum

If you tried to upload your files, it didnt work

But based on the sample you provided, I created 2 worksheets in the same file, and then used this to compare sheet2 (List2) against sheet1 (list1)....

=AND(VLOOKUP(A2,Sheet1!$A$2:$C$7,2,0)=Sheet2!B2,VLOOKUP(A2,Sheet1!$A$2:$C$7,3,0)=Sheet2!C2)
copied down

Where specifically should I copy down this. When I am done I just hit Formula -> Calculate Now correct?

Originally Posted by newdoverman

If the original list of data starts on Sheet1 A1 with the headers and actual data starting in A2 to C7 and your finished data is on sheet2 starting in A1 with the headers in row 1 and the data from A2:C5, enter this formula in E2 and copy down to row 5 and across to column F.

Formula:

Please Login or Register  to view this content.

In Column G2 of Sheet2 enter this:

Formula:

Please Login or Register  to view this content.

I am bit confused because you say "the headers and actual data starting in A2 to C7". If I select all (headers= NAME, CODE, CASH) included and I start from A2 I go down to C8. Is this a mistake of yours or I am the one that is doing something wrong?
Also, should I paste the

Formula:

Please Login or Register  to view this content.

to all cells in the table A2 to C5 of sheet2, then paste

Formula:

Please Login or Register  to view this content.

in each cell of the column G2 (down to row 5) ? Then hit Calculate now?
Please take a lookm at these screenshots:
sheet1.jpg
sheet2.jpg

Paste the formulae in the row where the data actually starts. EG. If the first row of data is in row two (just under the headers of the columns) row 2 is where the formulae start and copy down from there. In the Screen Shot, D2 is where the formula should be pasted and copied down.