Index(Match(Match issues

[Jamie Wagler]

Hello,

On my first page I have a shop calendar in weekly buckets.

Period	Week of
1	13-Jan-14
2	20-Jan-14
3	27-Jan-14
4	03-Feb-14
5	10-Feb-14
6	17-Feb-14
7	24-Feb-14

<colgroup><col><col></colgroup><tbody>
</tbody>

On the next I have a list of stat holidays

Holiday	When
New Year's Day	1-Jan-14
Family Day	10-Feb-14
Good Friday	18-Apr-14
Victoria Day	19-May-14
Canada Day	1-Jul-14
Labour Day	1-Sep-14
Thanksgiving Day	13-Oct-14
Remembrance Day	11-Nov-14
Christmas Day	25-Dec-14

<colgroup><col><col></colgroup><tbody>
</tbody>

I would like to populate the week with the holiday that falls within the week. Any suggestions?

 

[pplstuff]

Use a vlookup() with an approx. match.

 

[Jamie Wagler]

Do you have an example?

 

[Jamie Wagler]

Also, The calendar is being programmed to roll ahead and back. I need to be able to capture each of the holidays over a 26 week period.