How to search for data with no unique identifer?

[Hypothesis]

Hello,

I'm trying to use excel to write a logical statement that will identfy a relationship within a set of data and determine a net resuelt from that data.

Table 1:
[TABLE="width: 384"]
<TBODY>[TR]
[TD]Date</SPAN>[/TD]
[TD]ID Number </SPAN>[/TD]
[TD]Rating</SPAN>[/TD]
[TD]Prize</SPAN>[/TD]
[/TR]
[TR]
[TD]8/2/2011</SPAN>[/TD]
[TD]95</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[/TR]
[TR]
[TD]9/1/2012</SPAN>[/TD]
[TD]95</SPAN>[/TD]
[TD]5.4</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[/TR]
[TR]
[TD]9/19/2011</SPAN>[/TD]
[TD]81</SPAN>[/TD]
[TD]8</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[/TR]
[TR]
[TD]5/22/2012</SPAN>[/TD]
[TD]81</SPAN>[/TD]
[TD]9</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[/TR]
[TR]
[TD]5/23/2012</SPAN>[/TD]
[TD]81</SPAN>[/TD]
[TD]6</SPAN>[/TD]
[TD]?</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL></COLGROUP>[/TABLE]


Within the four columns above the only means I have of identfing the relationship is the ID number, but please note that there may be several instances of this number. For each line item I need to identify the date that was used A2 in this example (if we are using A B C D) and reference it with Rating to search another table (also in excel.) When searching the date, the field can be less then or = to the date (example a2) but I need the closest date as there may be many dates less then the referenced date.

In the example there is a direct corlation and the prize number that would be pulled in is "3" located in B4. I've been working on this for a few days now with no new idea's any help would be greatly apprciated.

Table 2:
[TABLE="width: 299"]
<TBODY>[TR]
[TD]ID Number</SPAN>[/TD]
[TD]Prize</SPAN>[/TD]
[TD]Date</SPAN>[/TD]
[TD]Rating</SPAN>[/TD]
[/TR]
[TR]
[TD]95</SPAN>[/TD]
[TD]4</SPAN>[/TD]
[TD]10/23/2014</SPAN>[/TD]
[TD]5.4</SPAN>[/TD]
[/TR]
[TR]
[TD]95</SPAN>[/TD]
[TD]4</SPAN>[/TD]
[TD]8/1/2013</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[/TR]
[TR]
[TD]95</SPAN>[/TD]
[TD]3</SPAN>[/TD]
[TD]8/2/2011</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[/TR]
[TR]
[TD]95</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD]9/6/2012</SPAN>[/TD]
[TD]4.1</SPAN>[/TD]
[/TR]
[TR]
[TD]81</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD]9/19/2011</SPAN>[/TD]
[TD]6</SPAN>[/TD]
[/TR]
[TR]
[TD]81</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD]5/22/2012</SPAN>[/TD]
[TD]8</SPAN>[/TD]
[/TR]
[TR]
[TD]81</SPAN>[/TD]
[TD]3</SPAN>[/TD]
[TD]5/23/2012</SPAN>[/TD]
[TD]3
</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=2><COL><COL></COLGROUP>[/TABLE]

 

[Hypothesis]

So I'm 90% of the way there. I'm using a vlookup with thee conditions. =vlookup("ID"&"Rating"&"Date", Table2, "Prize Column", True. The problem with true is that it isn't giving me the closest value, and I have it the tables in deciding order based on the ID Number, but I'm still getting inconsistant data. Any idea's for the last 10%? My current understanding of the True funtion is that its supposed to provided less then or equal to values. So that assumption may be wrong, but google tells me I'm right. If anyone has any idea how I can use this forula but make it so it looks for less then or equal to for the date correctly you will be my hero.