Forum Discussion

Vagif Huseynli's avatar
Vagif Huseynli
Copper Contributor
Mar 13, 2018

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

Resources