if the first column is column A and the second column column D
in Add column E and enter in E1
=match(D1,A:A,0)
this column will indicate the row that the Column A name is in
depending on what you want to do, you can sort if there is a one to one
cooerelation in the column data.

"Darren" wrote:

I have two columns one has a list of names; the second also has the same list
of names. Column one is not in ascending or descending order and the order
may not be changed. How can I get the names in the second column to match up
with it corresponding name in the first column.