LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup but with multiple results ORLANDO VAZQUEZ Excel Discussion (Misc queries) 22 February 24th 10 07:36 PM
Vlookup with multiple results M.A.Tyler Excel Discussion (Misc queries) 5 January 18th 09 03:46 AM
Vlookup help with multiple results Gerd Excel Worksheet Functions 2 October 28th 08 07:06 PM
How do I SUM multiple results from a VLOOKUP? garnm2 Excel Worksheet Functions 2 July 18th 08 07:56 PM
Multiple results in Vlookup sarajane18 Excel Discussion (Misc queries) 2 August 10th 07 08:54 PM


All times are GMT +1. The time now is 07:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"