I 'am trying to do a lookup that will return all the results based on the matching criteria, such that,(this is coming from the workbook i have attached) when user selects a company, and a product from that company it should return the product code. I can do this!
The problem I'm having is that i have the company who have products, but have different product codes for their products.(Please see the workbook, it will make more sense) I want to be able to produce all the product codes for the entered company and chosen product.
I been looking on-line, and i think i need to do a array for this, so while i try do it myself, any help from anyone would be much appreciated.