We use an excel 2000 form as an order form.

We enter the customer "bill to address" manually.

What is the best way to get excel to automatically fill
in the "bill to address" cells based on data entered in
a "customer number" cell.

We have a separate excel worksheet with "customer
numbers" and "bill to" data.

Thanks