format cell to recall client name-enter a client #

I am trying to format a timesheet so when I enter a client #, it
automatically pulls up the client's name.

Please help. I am using Excel for the timesheet and I have imported the
data from Microsoft Outlook.