Match Index from Data sheet to Individual Sheet

Hello Master Gurus
I am requesting assistance with this formula because my brain can't seem to figure it out and so I look to you for help.
I have a data sheet set up where the action performed is by columns and the subject number is by row. The individual sheets that represents 1 sheet per subject number. ie subject #1 information will go to "Subj Reimbursement (1)" tab where the actions are in Row format.

On the individual sheets I want to look up the Subject line # (Cell D1) match it to the # in Cells A44 thru A69 AND then look at the action [ Cells A10 thru A19 Subject Reimbursement tabs and Cells C42 thru L42] and place whatever value is in that intersection.

I have attached the file because I am not sure if I am explaining clearly enough. I did this once before and can't locate the formula.

Thank you for any help with this problem.

Try:

=VLOOKUP(D1,'Study Site Data Sheet'!$A$44:$L$69,ROWS($A$1:$A3))

copied down.

It doesn't seem to bring in the value I am looking for. If I use the Example line for 1 (A44) on the Study Site Data Sheet, the value for Unit Days on Subj Reimbusement (1) should be 2, OPVs =1 and Wash out > 10 Days but < 15 Days = 1. I am unclear how to get the numbers to populate. Where you state ROWS($A$1:$A$3) the logic is not clear. ie I am not getting what the purpose of that part of the function is suppose to perform.

Isn't D1 (1) supposed to match up to A44 in your sample and return stuff in corresponding row where column. The 2 and 0's, etc are in row 43 where you have EXAMPPLE in A43

If you want INDEX/MATCH version:

=INDEX('Study Site Data Sheet'!$C$44:$L$69,MATCH($D$1,'Study Site Data Sheet'!$A$44:$A$68),MATCH(A10,'Study Site Data Sheet'!$C$42:$L$42,0))

copied down.

The ROWS($A$1:$A3) is used to increment the number starting at 3 as you copy down, so the VLOOKUP() references the corresponding column number as you copy down.

The Index/Match version was what I was looking for. Thanks so much for your help.

It should still give the same result as the Vlookup, though.