Help Please!!!

I have 2 colums, one which shows sales people the other which shows Dollar
amount.

Can I formulate a cell to ask wherever you see Sales Person A then copy the
adjecent cell throughout a range or column?