Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Summing lookup values | Excel Worksheet Functions | |||
How do I use vlookup with two lookup values? | Excel Worksheet Functions | |||
Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
How do I lookup data with two comparison values? | Excel Worksheet Functions | |||
vlookup using two lookup values? | Excel Worksheet Functions |