Ok, so I have two sheets with trade data......

Sheet 1:
This sheet has a long list of trades. Each security has a unique identifier, but the identifier could show up more than once due to a trade of the same security - but on a different date. Data is at the 'trade ticket' level.

Sheet 2:
This sheet has the same data but with different prices (adjusted for concessions/costs/etc). There are also duplicates in this data because it is at the 'account level' instead of the ticket level (in other words, if it were a trade for 20,000 for one acct and 10,000 for another account...it would be two lines on this sheet versus Sheet 1 would just be one line for 30,000 -- the rest of the information would be the same).

Problem: I'm trying to pull the price from Sheet 2 into the appropriate row for the trade in Sheet 1, based on matching on two factors (date and identifier).

I am not as Excel-ready as I probably should be for this project, detail appreciated.

~B