How can I return a value in a table if the lookup value is in a range equal
to or between two other columns? I would prefer not to create a macro for
this. Is there a combination of built in funtions that would work?

Example:
Look up Payclaim letter in column 1 for the date July 1st.

A B C
1 Pay Claim Letter Start Date End Date
2 A Jul 1 Apr 3
3 B Apr 4 Mar 25
4 C Mar 26 June 30