Have a look at the vlookup-function. However, it requires the list to be searched in to be in ascending sequence. So you can't use the same list for access with names and number at the same time.

This is the kind of problem they invented a 'database system' for. In MS Office Professional you'll find MS Access.

Hope this helps,


Kees