I tried placing $ in front of the values that I want constant,
but they still increment.

Post the *EXACT* formula you tried.

Biff

"tommcbrny" wrote in message
...
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