Using Excel 2000, and with a list created of two columns consisting of a
number as text in the first column and a corresponding name in the second.

In a new workbook, I need to enter one of the numbers in a column, and then
in the next column have the corresponding name automatically entered when I
press Enter.

Is this possible, please?