Help re matching date range to an index number

[Julio Medallion]

Hi,

Hoping someone out there can help.
I am trying to match a date range to a published index number-in order to extract an index value-example below

Index values

A	B	C
1	Index Type	Index Value
2	Feb 2011	100.0
3	May 2011	101.0
4	Aug 2011	102.0
5	Nov 2011	103.0

<tbody>
</tbody>

Date Products issued

A	B	C
1	Date issued	Index value
2	1/4/2011
3	1/6/2011
4	30/9/2011
5	30/11/2011

<tbody>
</tbody>

Formula in index value-Date Products Issued table (C2), should group by date the product was issued, i.e.1st April 2011 should link to the Feb 2011 index, that is all loans issued from March to May 2011 should return a value of 100.0 etc.

By way of explanation the May index is published at the start of June and the August index is published at the start of September etc..
Would it possible to do this formula via Index and Match functions? Sorry if this is confusing I will give further clarification if needed.

Thanks,
Julio

 

[Julio Medallion]

Hi sorry in case there is confusion on the date format-1/4/2011 I assume is 1st April-I hope this hasn't confused USA users who may use 4/1/2011 as the date format for 1st April 2011