Vlookup, 2 criteria, closest date?

[andrewwhitfield]

I have hit a bit of a dead end and would be grateful for any pointers.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
ID Value Date Value<o></o>
SW123 1-Jun-2011 0.00<o></o>
SW124 1-Jun-2011 0.00<o></o>
SW125 1-Jun-2011 13526597.13<o></o>
SW126 1-Jun-2011 85637799.37<o></o>
SW127 1-Jun-2011 32026961.34<o></o>
<o></o>
The above is an example of the range I need to look up and there may be several entries for each ID across a date range of a calendar month.<o></o>
<o></o>
I am trying to retrieve the value in column C where the said ID matches a specified date, however it may be that the date is not in the list in which case I would need the closest previous date to be found and the value in column C returned.<o></o>
<o></o>
I hope that makes some sense... any help would be greatly appreciated.<o></o>

Andrew

 

[Robert Mika]

Excel Workbook
	A	B	C
1	SW123	01-Jun-11	0
2	SW124	01-Jun-11	0
3	SW125	01-Jun-11	13526597.1
4	SW126	01-Jun-11	85637799.4
5	SW127	01-Jun-11	32026961.3
6	sw128	02-Jun-11	2000
7
8
9
10	SW128	03-Jun-11	2000
Sheet2

 

[andrewwhitfield]

Hi, thanks for your reply... looked promising, however I get #N/A error when I try and replicate this. Any ideas? I can't see where the formula references the date in Row 10, perhaps i'm just missing the obvious though.

thanks,

 

[andrewwhitfield]

Apologies, ignore my previous thread, the formula works perfectly well!!