Suppose your date is in D1. Then in E1 you can use this:

=VLOOKUP(D1,A$1:C$20,3)

Copy it down as required.

Hope this helps.

Pete

On Jan 20, 11:55*pm, AJ wrote:
I am trying to compare a date for an invoice to see if it falls between a
date range and then I want it to return a value.

For example
Column A * Column B * *Column C
10/4/2008 * 11/2/2008 * Oct 2008
11/3/2008 * 12/1/2008 * Nov 2008
12/2/2008 * 01/03/2009 *Dec 2008

If I have a date of 10/28/2008 in another field, I would like for it to
search to see what date range (between column A and B) it would match and
then return the value from column C. *There will be multiple dates that I
will need to check.