Forum Discussion
Vagif Huseynli
Mar 13, 2018Copper Contributor
Finding all the prices and purchased date of product based on detai code
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?
No RepliesBe the first to reply