| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
V Lookup
How can I copy a vlookup formula down without the cells changing every row
down? Thanks a bunch! rojobrown |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
V Lookup
Presumably you do want the lookup value to change every row (otherwise you'll
get the same answer every time), but not the table array. Change that portion of the formula to use absolute references rather than relative references: =vlookup(a1,$C$20:$E$35,3,false) rather than =vlookup(a1,C20:E35,3,false) "rojobrown" wrote: How can I copy a vlookup formula down without the cells changing every row down? Thanks a bunch! rojobrown |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
V Lookup
That's exactly what I needed....
-- Thanks a bunch! rojobrown "rojobrown" wrote: How can I copy a vlookup formula down without the cells changing every row down? Thanks a bunch! rojobrown |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another way to lookup data | Excel Worksheet Functions | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Lookup Function Problem | Excel Discussion (Misc queries) | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Hybrid Mode
