Jean, I email you a file yesterday... Hoping you received it. I would like
cell not to have to be in a cluster, as you see in CustID. that is my
misunderstanding.
Thanks again.

"Jean-Guy" wrote:

Hi,

There's really no need, try this and if you can't get it working after then
you can send it to me!

just open a blank worksheet, in cells F1 to F4 type a few customer names, in
cells G1 to G4 type their phone numbers, in cells H1 to H4 their address...in
B1 type =VLOOKUP($A$1,$F$1:$G$4,ROW(A2),0) and copy down to B2, now type any
customer name from the table to see their info.

Regards!
Jean-Guy
dotcom



"MMANDIA" wrote:

I would love to email you my file so you can see what I have.

"MMANDIA" wrote:

I have created a basic Work Order with drop downs, worls great. Now I would
like to add customers to a worksheet drop down. Once I select the customers
name, I would like to fill in address, Phone, Customer ID, etc. in work order
to print invoice.
I will put all this info into a worksheet in the workbook.
How can I do this in Excel.