Use VLOOKUP
Assuming your drop down is in A1 in sheet 1 and your account no and names
data is in Sheet 2, COl A & B
then enter this in B1 of sheet 1;
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

"GA85" wrote:

I have a drop-down list created with my account numbers. When I select an
account number from the drop-down list, I would like for the account name to
appear in the cell to the right of the cell with the account number. Any help
would be great! THANK YOU!