Simple way to return multiple look up values?
Posted on 2011-03-16
The work flow:
The user selects the company using a drop down and i want to display a list of products made by that company.
- i vlookup the company index based on the company thats selected
- i have a value lets say "2" in a cell
- i want to search the sheet below and return all products with the company index of 2.
The sheet follows the pattern below with 100's of rows. A simple formula is what i'm looking for.
Company Index | Product Index | Company Name | Product Name | Sales data