help with this tricky formula is greatly appreciated.

`='[DATA.xlsm]2018'!$G$6 *this formula works, but . . .`

I need the formula to determine where to find the data. See image. The formula in in the VALUE column B. The QTR info in column A tells me where to look for the data in the image.

The four QTR matching fields are D1, I1, N1, S1. Then the OFFSET is 3 columns (for example: D1=1Q18 and col G is the data column, col L for 2Q18, etc) and the OFFSET row is 5 (meaning row 6). {Hopefully OFFSET(5,3) is correct}

On row 10 I need the formula in B10 to read 1Q18 in A10 and {know} to go to '[DATA.xlsx]2018' and find that "1Q18" is D1 and then use the OFFSET(5,3) to find the value "1.80"

When we get down to row 14 on the FORMULA sheet it'll see "1Q19" in A14 and {know} to go to '[DATA.xlsx]2019'. Each year has a new tab-sheet named by the 4-digit year.

I hope I was clear enough and I certainly hope the png images a visible. Thanks in advance for any and all help.

`INDIRECT`

. – cybernetic.nomad Aug 28 '18 at 21:54