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
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