Looking up values contingent upon multiple requirements

Hello - I am currently trying to figure out a simple way to generate a time series from a spreadsheet that has all of the timeseries data on one sheet. The tricky part is that I have multiple descriptions each for the same day that all have different values depending on which day I am looking for. A very simple example would be as follows:

Date: Bond: Value:
today Bond1 1
today Bond2 2
today Bond3 3
today Bond4 4
today+1 Bond1 5
today+1 Bond2 6
today+1 Bond3 7
today+1 Bond4 8
today+2 Bond1 9
today+2 Bond2 10
today+2 Bond3 11
today+2 Bond4 12

So, I'd like to be able to lookup a value for today+1 for bond1 and get the result of "5" then on today+2 for bond1 get the result of "9" I think I should be able to do this with Index(Match( but I don't know how to do the lookup so that I get the "Value" for the whichever bond on whichever day I am looking for. It can't be that hard, I am just unable to find the thread that can help me solve this. Any help is appreciated.

Example attached. New information is added daily and is in a static format so I can't reformat all the data every time.

Thanks for the help!

Sorry - In this file I would like to write a formula that says, i want to look up bond1 on 12/1/12 and return the price (100), then bond1 on 12/2/12 and return the price (99.5).

Thanks again.

Ok - Here is a sample file INCLUDING the results I am trying to get. On the let in the first 4 columns is the data that is added to daily and on the right (which will actually be in a separate sheet) are the parameters I would like to use to locate the data. I am looking for the data contingent upon the date field AND the price or yield field referencing a specific bond.

Let me know if you need more guidance on what I am looking for. Thanks for your patience.

See the attached

This does accomplish what I request in my simple example, the problem is that in the real example I will change the fields I look up as I will want to look at different relationships. So, in my real workbook I have created dropdowns that have all of the values I may want to pull in, (in this example I would have a dropdown for bonds 1 through 10 and another dropdown for price and yield.) Do you have a way to automate which field is being looked up so that when I flip the dropdown the column it looks at moves as well?

We're making progress. Thanks.