Hi Ed,

You can use Vlookup for this after first creating a unique ID for each
security/date combination.

1. In the first sheet insert a column before the security to use as
your key (ID).
2. Put a formula in each of the cells in this column that combines the
security and the date (eg in cell A1 you'd put =B1&C1). Now each
record has a unique identifier to look up.
3. In the 2nd sheet, in the column after the date put your vlookup
which should look something like this (in cell C2):  =VLOOKUP($A
$1&B2,Sheet1$A$1:$D$1000,4,FALSE). This assumes you have the security
code in cell A1 and then the list of dates runnning down column B. You
could put the key (ID) on each row (for example in column A) if you'd
prefer and reference this as the first argument in your vlookup.
Basically it will now search the range in the first sheet looking for
a security & date match in the column you just created.
4. Note that it'll return #N/A if there is no match (eg if you didn't
deal in that security on that day). If you want it to return a blank
cell instead, use ISNA as follows: =IF(ISNA(VLOOKUP($A$1&B2,Sheet1$A
$1:$D$1000,4,FALSE)),"",VLOOKUP($A$1&B2,Sheet1$A$1:$D$1000,4,FALSE))

HTH

Let us know how you go or if you need clarification on any of this.

Cheers,
Troy.

Unprotect Any Spreadsheet... Without The Password... In Just Seconds
Get eXL_unProtect today for less than you'd pay for lunch
www.eXtreme-eXcel.com
Don't Let Anyone Lock You Out Of A Spreadsheet Again!

Hiya,

You just need to stack some fields to create an index and use VLOOKUP

First insert a new column to the left of the price. (You can later
hide this formula)
Enter a formula in this cell against each entry row, for Row 1 in cell
C1, this would be =A1&"/"&B1, result below
Columns:-
A                             B
C                                   D
TIVO US Equity        23-Jul           TIVO US Equity/23-Jul    136
TIVO US Equity        24-Jul           TIVO US Equity/23-Jul    135.5

Then in your second sheet where you want the price to appear for that
Security/Date use a VLOOKUP Formula to look in the stack.

I have produced an example spreadsheet for you to view the exact use
of formula.
I have also made use of the ISERROR function to handle occasions where
the VLOOKUP fails.

http://somethinglikeant.110mb.com//excel-ant/examples/Returning values
against two criteria Options.xls

Hope this helps

Ant
http://www.excel-ant.co.uk