Auto Fill

J

Jay

My excel table (Order) is as follows:

Date Customer Tel # Order #
1/26/06 Cathie Lee 319-345-3744 35297853
1/26/06 Jack Morrison 232-475-3438 75375908
..
Every day I have to enter, in customer column, customer names who makes
order.
I have separate Excel table( Customer Info) with all info on customers as
follows

Customer Tel # Term ..............
Cathie Lee -------------

Question) In a customer columm of an order table, I just want to type couple
of customer alphabet and to make the full name and Tel # should pop up. How
can I relate Customer Info and Order tables together?
 
P

pinmaster

Use a validation list, go to the customer info table and select all the
customer names, then hit Ctrl+F3 and enter a name for your list....say
"custname" hit Ok.

Then go to the order table, select a cell in the Customer column and go to
Data/Validation, select "list" from the "Allow" menu and in the formula box
below type: =custname hit ok and copy down as far as needed. Now all you need
to do is select the customer from the list. For the tel # use a vlookup
formula.

assuming your customer column is B then in C:

=IF($B1="","",VLOOKUP($B1,enter your customer info range here, COLUMN(B:B),0))
copy down and across if needed.

HTH
JG
 
Top