Look in Excel help at the vlookup formula.

--
Regards,
Tom Ogilvy


"Dr. Phil" wrote in message
...
To Whom It May Concern:

We are in the process of creating a customer database, consisting of about
900-lines with 20 columns per line, sorted by customer drawing number.
This
same data is used repeatedly to process new customer orders

When a new order is received, we would like to search this database by
entering the customer drawing number on a form, and then have the data in
all
the cells in the associated row automatically print on the form.

How can this be done in Excel?

Dr. Phil

--
Dr. Phil