Question on VLookUp; Attempting to retrieving data from another sheet reference adjustment

I wanted to construct a VLookup situation extensively involving retrieving data from another sheet. I ran into a problem with Excel's hardwired reference adjustment.

To wit, I wanted to have a VLookup where I would have the second row (the first row contains labels) would all refer to the first cell in the second row as the item searched for in the array. I did not want the cells to adjust references as they progressed to the right.

Next, I wanted the VLookup formula to automatically adjust references for subsequent rows by advancing only one row.

He's just not using $ correctly to drag right and down.

An update on this situation.

=VLOOKUP((OFFSET($D$2,Offset!A1,0)),'Sheet1 (2)'!$B$2:$R$72,(ADJ!A1),FALSE)

I fashioned a somewhat complex solution. The Offset sheet features increments of one (1) from a starting point of zero (0); therefore, the VLOOKUP progresses by one row for progression. ADJ sheet also causes an advancement by one for columns.

For the Offset sheet, the numbers in each row remain the same (e.g. one row of only the number 1). For the ADJ sheet, the numbers in each column stand as the same (e.g. one column of only the number 7).