Paul, the "Report" sheet shows the destination cells. All column of 4 cells have a highlighted cell above or under. They are all numbered. Row 2 in "Data" is in column D12
15 of Report. The address of D12
15 is 4 (D11). Row 4 in "Data" is in column I16:I19 of Report. The address of I16:I19 is 24 (I20). Of course any Row in Data can be placed anywhere in Report. That is why I cannot use a normal lookup formula