Hmm... this isn't the result we were looking for. All the rows in the worksheet were sorted, and now the lookup tables have been messed up, and all of the lookups in columns D and E are incorrect.