First you would create a table (that you probably already have) containing
the product number and the product description. Then in the second cell
(where you want the product description to appear, use a VLOOKUP formula.
Look it up in Help. HTH Otto
"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