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.