You need a 2 column table of numbers and descriptions
use the vlookup function to get the description

I.e. something like =VLOOKUP(B1,$C$1:$D$11,2,false)

where
B1 is your cell with the number
C1:D12 is the range with the table
2
is the column to look in
false indicates you need an exact match
the numbers in C column should have been sorted ascending

--
Greetings from New Zealand
Bill K


"newriver" wrote in message
...
what would be the process to enter product numbers in one field and have
the
product description appear in the next field to the right