VLOOKUP to reference cell, not column number

Trying to write a vlookup formula to look-up the date of the column instead of the row number, so when I copy the formula, I don't have to continue to change the ROW number inside my formula for my 52 week spreadsheet.

=IF(ISERROR(VLOOKUP($A2,'CURRENT SALES'!$A$1:$BJ$190,4,FALSE)*$D2),0,VLOOKUP($A2,'CURRENT SALES'!$A$1:$BJ$190,4,FALSE)*$D2)

Tried all kinds of MATCH, INDEX, LOOKUP combinations, just can't seem to find the right combination.

Thanks for any help you can provide.