[RESOLVED] Creating blocks with relative formulas

[TnTinMN]

thank you so much

You are welcome.

i changed the worksheets so the values in column A match the lookups in column A

I forgot that I was going to suggest that you use Named Range Array to store the ranges for the different quarters, then that name could be incorporated into the formula. But whatever works for you.