View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tommcbrny tommcbrny is offline
external usenet poster
 
Posts: 57
Default Keep lookup values constant

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