G
Guest
Hello,
I entered a lookup function that works the way I need it to. I'd like to
now apply this function to the remaining cells in a column beneath where the
function is entered. When I drag the corner of the cell down, however, the
lookup values that need to remain constant instead increment.
I tried placing $ in front of the values that I want constant, but they
still increment.
How do I keep these values constant so that the lookup function looks at the
same columns / cells to determine the correct cell value?
Thanks,
Tom
I entered a lookup function that works the way I need it to. I'd like to
now apply this function to the remaining cells in a column beneath where the
function is entered. When I drag the corner of the cell down, however, the
lookup values that need to remain constant instead increment.
I tried placing $ in front of the values that I want constant, but they
still increment.
How do I keep these values constant so that the lookup function looks at the
same columns / cells to determine the correct cell value?
Thanks,
Tom