View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neall Neall is offline
external usenet poster
 
Posts: 95
Default 1 Vlookup multiple results in different columns

Now that I have my vlookup working I now have a new situation

I have a customer number which I use my vlookup to get data such as
Cust name
renewal date
product code
product description

Now the new problem is if I have one customer ID that has 5 different
products, how can I get all 5 products into my result and each in a different
cell. each customer will have no more than at the most 10 part numbers per
customer number

Thanks in advance







--
Neall