Excel: Can Excel automatically recognize what name coordinates with certain accounts?

This is for a commissions report where I enter the sales rep who earns commissions on accounts they call on. Currently I am putting the accounts in ascending order and manually entering the sales rep. Is there a way that I can enter the account in one column and have the other column automatically recognize who it belongs to?

This question generated 7 answers. To proceed to the answers, click here.

This thread is current as of April 22, 2017.

For more resources for Microsoft Excel