Sorry... yes, US (mm/dd/yyyy).

And you are Correct... I want "D" to have "B's" value. The catch is
there will be multipule ID's and some of the ID's will repeat
themselves but I only want to have one entry in "D" per unique ID.

another Example:

ID4 appreas 4 times in "A" with these dates 1/1/2005, 2/1/2005,
3/1/2005, 4/1/2005. in "C"
Cell "A11" = 3/1/2005
I want the PLAN that is associated with ID4 on the date 3/1/2005

Hopefully this all makes sense.

Thanks again.

Tysone