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!

Have you tried the VLOOKUP function for this?

yeah! Used that. Let me explain my problem more clearly with an example. This is the data I have in the two sheets

Stock Account Date Quatity Price
A sam 15-Oct-08 1,300,000 38.2
B sam 15-Oct-08 70,000 52.1
C sam 15-Oct-08 25,000 51.8
D monica 16-Oct-08 1,166,594 38.9
E jia 16-Oct-08 50,000 49.3
F rachel 16-Oct-08 50,000 49.7
G rachel 17-Oct-08 86,936 86.0
A rachel 3-Nov-08 6,700 594.5
K rachel 3-Nov-08 31,449 349.0
L rachel 19-Nov-08 6,450 457.8
A noel 19-Nov-08 2,516 323.1
G noel 19-Nov-08 4,034 323.8
B noel 20-Nov-08 1,450 314.9
D noel 20-Nov-08 1,350 313.0

Now in a new sheet I have created a drop down list. So when we select a company from this list, I want it give the list of all the transactions. So if I select A, it shud give all the 3 transactions in A with the deatails in the 4 other columns towards the right also.

Attached a file with the data represented more clearly for convenience.

Since the stocks have multiple entries in one column, it's best to use a pivot table.