typing in one cell automatically brings up something else in next
 

I want to create an automatic order form, so that when I type the description
of a product it automatically brings up the order number in the next cell.

typing in one cell automatically brings up something else in next
 

Where will order number be defined/obtained from?

If it is a list on a worksheet, it should be just a lookup, but what is the
rule to determine that number?

--
__________________________________
HTH

Bob

"Cherry Gordon" <Cherry wrote in message
...
I want to create an automatic order form, so that when I type the
description
of a product it automatically brings up the order number in the next cell.