I hate merged cells

Remove merged cells and fill the same data to the cells.

Then in A3 cell of Comp Sheet
Formula: copy to clipboard
=VLOOKUP($B$3,DATA!$A$4:$F$13,3+ROW(A1),1)

Drag the formula down to A4.