Good afternoon!
I would like to find a way to automatically attach a client name to a client
number. For instance, if client is called "thisismyclient", and his client
number is 00001, is there a way in the spreadsheet to automatically populate
the correct name by just typing in the client number?

Many thanks! PS, I work on Excel 2003.