I have a spreadsheet that has date ranges and an associated group ID.
In another sheet I enter a date and I want to refrence the date ranges
to pull over the group ID. I thought I could use Lookup & reference,
index. The attempt failed. So I am looking for suggestions.
Thank for any help.
Brad P.


--
Brad P
------------------------------------------------------------------------
Brad P's Profile: http://www.excelforum.com/member.php...o&userid=24049
View this thread: http://www.excelforum.com/showthread...hreadid=376575