The "Current Plan" is the formula I'm trying to create:

Starting Point:

1 A B C D
2 NAME PLAN Effective Date Current Plan
3 ---- ---- -------------- ------------
4 ID1 1 1/1/2005
5 ID1 3 2/1/2005
6 ID2 2 5/1/2004
7 ID3 2 2/1/2005
8 ID3 4 9/1/2005
9
10 AS OF DATE:
11 3/1/2005


What I'm trying to get to is the "Current Plan" based on the "AS OF
DATE" I put in.


Ending Point:

1 A B C D
2 NAME PLAN Effective Date Current Plan
3 ---- ---- -------------- ------------
4 ID1 1 1/1/2005
5 ID1 3 2/1/2005 3
6 ID2 2 5/1/2004 2
7 ID3 2 2/1/2005
8 ID3 4 9/1/2005 4
9
10 AS OF DATE:
11 3/1/2005


I figure I need some sort of between formual or a "<" but "" formula.


Can anyone help?

Thanks.

Tysone