Finding all the prices and purchased date of product based on detai code

Occasional Visitor

Hi everyone, I have data  in one worksheet that contains all of the products that we have bought until today. In another worksheet I prepared vlookup formula that when we buy new product it looks from another sheet and say the price. But, vlookup function gives only one price and place, however sometimes I have different prices for a product . I want that when i enter a detail code in a cell , excel finds the match of that code from another sheet and show all of different prices for that code if there is.  How can I do it in a simplest way?



0 Replies