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.