Copy Cell in Column (Drag down)

[craigwojo]

Hi everyone,
I know how to drag down a cell and carry the formulas and such along with it. Also know that if I hold down "ctrl" it keep the numbers the same instead of counting up from the original cell...
I can't seem to do this with my VLOOKUP formula cell. This is my cell content (=VLOOKUP(D228,DATA!G1:H9,2,0)). Now when I drag to copy the formula down (either without ctrl or with ctrl held) it doesn't keep the table_array the same.

Am I doing something not right or what?

TIA, Craig

 

[Special-K99]

Insert $ signs to anchor the table range
=VLOOKUP(D228,DATA!$G$1:$H$9,2,0)

 

[craigwojo]

Insert $ signs to anchor the table range
=VLOOKUP(D228,DATA!$G$1:$H$9,2,0)

Thank you. Thank you. Thank you.