I have two sheets of information. First one has 5 columns giving me the name of the stock, account, date, quatity bought and price at which it has been bought. The second sheet has similar data except it is for all the stocks sold. I need to create a function in another sheet in which when I pickup a stock from a drop down list already created, it will given me all the transactions in that stock from the two sheets.

Need it asap. Please help!