Good morning,

I need a formula to define a dynamic range that varies based on a search criteria & then an offset. It's a bit of a complex problem to explain in words so I have tried to explain it in a little spreadsheet attached!

help.xlsx

Thanks very much in advance,