In Cell D14 put "=Vlookup(A1,$E$2:$F$5,2,true)"
This will return the account number (column 2 of List 2) into the sorted column 1. Copy that formula down to the end of the sorted List 1.
From what you've said, that should give you the results you want.
__________________
The secret to great marksmanship is deciding what the target was AFTER you've shot.
|