Thread: vlookup - HELP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fuzzy Fuzzy is offline
external usenet poster
 
Posts: 35
Default vlookup - HELP

Somebody please help me!!

i have two sheets - both sheets having the customer name common.
the first sheet has one column with information regarding the customer...

eg:
Cust A - Contact A
Cust A - Address A
Cust A - ZipCode A
Cust B - Contact B
Cust B - Address B
Cust C - Contact C1
Cust C - Contact C2
Cust C - Address C
Cust C - Zipcode C

in my next sheet, i want the vlookup to work in such a way, that one
customer's details get aligned into one cell - like below

Cust A - Contact A,Address A,ZipCode A
Cust B - Contact B,Address B
Cust C - Contact C1,Contact C2,Address C,Zipcode C

Can somebody please help me....sometimes, one customer can have atleast 10
details...