changing order

[speckled knob]

I have a list of employee names in column a and the order of these names is constantly changing depending on what job the employees are assigned. I have another sheet where these same names are listed in alphabetical order.

what I am trying to do is to get the earnings (column b) of the employee in sheet 1 to be copied next to their name in sheet 2 (column b). Is there an easy way to do this?

 

[jmthompson]

Sounds like you want a vlookup:
If employee name in sheet one is in column A and the earnings are in column b
and
the employee name in sheet two is in column A, place this formula in sheet 2, b2, Fill down

=VLOOKUP(a2,Sheet1!A:B,2,False)