Home |
Search |
Today's Posts |
#1
|
|||
|
|||
copying LOOKUP formula
I am trying to copy a LOOKUP formula down in my column to always look at the
same set range of cells for the correct value, but when I drag my formula down it the formula shifts the range of cells it is looking at for the correct value. There must be an easier way than re-doing the formula in each cell. Please help! |
#2
|
|||
|
|||
Select the lookup range (highlight) with the mouse in the formula bar and
press F4 or manually insert dollar signs like A2:H4 becomes $A$2:$H$4 Regards, Peo Sjoblom "R Birk" <R wrote in message ... I am trying to copy a LOOKUP formula down in my column to always look at the same set range of cells for the correct value, but when I drag my formula down it the formula shifts the range of cells it is looking at for the correct value. There must be an easier way than re-doing the formula in each cell. Please help! |
#3
|
|||
|
|||
Peo - thank you very much - that was perfect!
"Peo Sjoblom" wrote: Select the lookup range (highlight) with the mouse in the formula bar and press F4 or manually insert dollar signs like A2:H4 becomes $A$2:$H$4 Regards, Peo Sjoblom "R Birk" <R wrote in message ... I am trying to copy a LOOKUP formula down in my column to always look at the same set range of cells for the correct value, but when I drag my formula down it the formula shifts the range of cells it is looking at for the correct value. There must be an easier way than re-doing the formula in each cell. Please help! |
#4
|
|||
|
|||
Thanks for the feedback
-- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "R Birk" wrote in message ... Peo - thank you very much - that was perfect! "Peo Sjoblom" wrote: Select the lookup range (highlight) with the mouse in the formula bar and press F4 or manually insert dollar signs like A2:H4 becomes $A$2:$H$4 Regards, Peo Sjoblom "R Birk" <R wrote in message ... I am trying to copy a LOOKUP formula down in my column to always look at the same set range of cells for the correct value, but when I drag my formula down it the formula shifts the range of cells it is looking at for the correct value. There must be an easier way than re-doing the formula in each cell. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I have a formula lookup a sheetname? | Excel Worksheet Functions | |||
Copying an array formula... | Excel Worksheet Functions | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |