I need to build a formula that finds a text reference in a vertical
list, e.g finds "Feb" in a list of months. Having found the text, I
need the formula to return in text format the cell references of a
range of a cells located in the same row as the found text and
immediately to the left, e.g if "Feb" is found in cell A2 the formula
would return the range reference (not the values) of the next 10 cells
in the same row, in this case, A3:J2

I've been looking at Address, Index, Match etc. but I can't figure it
out.

I'd appreciate any suggestions.

Bob
Nottingham UK