Hi excelledsoftware,



I will send out the file later today as I am at work, probably around 6 or 7pm. Again I need to use vlookup to search for stock names in a "sell" table using names in the "buy" table to return the price column corresponding to the stock in the "sell" data. There are several stocks of the same name in the sell table, all on different dates with different prices. Vlookup brings back the most recent stock name with corresponding price column, which causes stocks to have the most recent price, not the price that corresponds to the date when it was sold. I need the stock corresponding to a certain buy date to have the correct sell price.

Thank you for the quick reply. Cheers!