Good afternoon,

I want to use a lookup-type function to look in cell A2 (Sheet 1) for instance, and find cells that match in column A (Sheet 2); then, return the CELL REFERENCE (for example, A2:A6), instead of the value. Does anyone know if this can be done?
Sheet 2 column A is sorted alphabetically.

EXAMPLE.
Sheet 1
Column A Column B
Row 1 Monday A2:A6

(Cell B1 contains the formula resulting in a cell reference "A2:A6", rather than the value "Monday")

Sheet 2

Column A
Row 1 Sunday
Row 2 Monday
Row 3 Monday
Row 4 Monday
Row 5 Monday
Row 6 Monday
Row 7 Tuesday
Row 8 Tuesday
Row 9 Wednesday
Row 10 Thursday
Row 11 Thursday

Thanks.