Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep lookup values constant
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep lookup values constant
Here is the formula entered in the first row of the column:
=LOOKUP(H1,A1:A4,B1:B4) I'd like to drag this formula to the rest of the rows, but have only the lookup value (H1) increment while the lookup vector and result vector remain unchanged. Is this possible? Thanks, Tom "Biff" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep lookup values constant
Never mind, I got it...
=LOOKUP(H1,$A$1:$$4,$B$1:$B$4) Thanks to anyone who looked for me. Tom "tommcbrny" wrote: Here is the formula entered in the first row of the column: =LOOKUP(H1,A1:A4,B1:B4) I'd like to drag this formula to the rest of the rows, but have only the lookup value (H1) increment while the lookup vector and result vector remain unchanged. Is this possible? Thanks, Tom "Biff" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep lookup values constant
And what was the answer to Biff's question? Where did you put the $
symbols, and what did you want to remain constant? -- David Biddulph "tommcbrny" wrote in message ... Here is the formula entered in the first row of the column: =LOOKUP(H1,A1:A4,B1:B4) I'd like to drag this formula to the rest of the rows, but have only the lookup value (H1) increment while the lookup vector and result vector remain unchanged. Is this possible? Thanks, Tom "Biff" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep lookup values constant
That would, of course, have failed, Tom. I guess you mean
=LOOKUP(H1,$A$1:$A$4,$B$1:$B$4) [Hint: it's usually safer to copy & paste, rather than to retype.] If you've looked at the help for absolute addressing and relative addressing, you'll have seen that if you were only filling down rows, and not across columns, you could get away with =LOOKUP(H1,A$1:A$4,B$1:B$4) -- David Biddulph "tommcbrny" wrote in message ... Never mind, I got it... =LOOKUP(H1,$A$1:$$4,$B$1:$B$4) Thanks to anyone who looked for me. Tom "tommcbrny" wrote: Here is the formula entered in the first row of the column: =LOOKUP(H1,A1:A4,B1:B4) I'd like to drag this formula to the rest of the rows, but have only the lookup value (H1) increment while the lookup vector and result vector remain unchanged. Is this possible? Thanks, Tom "Biff" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |