Given a VALUE in a table, ascertain RANGE in another table
 

I have month values in cells A1:A12. I have a relative range name
called Date whose refers to value is '=$A1'. So in row 7, Date refers
to A7, and in row 11, Date refers to A11, etc.

The values in A1:A12 are derived from a larger SourceTable on another
sheet. Given Date (column A of the current row), I would also like to
be able to define the cell in SourceTable, so that I can ascertain a
range based on that cell.

I hope that's clear, but I can explain further if required.

Thanks in advance

Paul Martin
Melbourne, Australia