| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you 'fix' an array of values for use with VLOOKUP
I would like to use VLOOKUP to reference a set of data. When I paste the
formula using 'Fill Down' the array values change. Is there a way to fix the array? Should I use a different function or is there a way to manipulate the Fill Down function? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you 'fix' an array of values for use with VLOOKUP
Make the reference absolute so by using the '$' so that it doesn't change
when the formula is copied. ie: =VLOOKUP(E2,$A$2:$B$5,2,FALSE) instead of =VLOOKUP(E2,A2:B5,2,FALSE) -- Hope this helps. Thanks in advance for your feedback. Gary Brown "mavisB" wrote: I would like to use VLOOKUP to reference a set of data. When I paste the formula using 'Fill Down' the array values change. Is there a way to fix the array? Should I use a different function or is there a way to manipulate the Fill Down function? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you 'fix' an array of values for use with VLOOKUP
Gary,
Best Wishes & MANY THANKS. Just what I needed! "Gary Brown" wrote: Make the reference absolute so by using the '$' so that it doesn't change when the formula is copied. ie: =VLOOKUP(E2,$A$2:$B$5,2,FALSE) instead of =VLOOKUP(E2,A2:B5,2,FALSE) -- Hope this helps. Thanks in advance for your feedback. Gary Brown "mavisB" wrote: I would like to use VLOOKUP to reference a set of data. When I paste the formula using 'Fill Down' the array values change. Is there a way to fix the array? Should I use a different function or is there a way to manipulate the Fill Down function? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you 'fix' an array of values for use with VLOOKUP
You can also give the table array a defined name.
=VLOOKUP(A1,myname,2,FALSE) Gord Dibben MS Excel MVP On Thu, 15 Jan 2009 04:34:00 -0800, mavisB wrote: I would like to use VLOOKUP to reference a set of data. When I paste the formula using 'Fill Down' the array values change. Is there a way to fix the array? Should I use a different function or is there a way to manipulate the Fill Down function? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Am I able to 'fix' the results of a formula into a cell? | Excel Discussion (Misc queries) | |||
| Sum an array of vlookup values | Excel Discussion (Misc queries) | |||
| Vlookup on an array of values | Excel Discussion (Misc queries) | |||
| Array: Counting multiple values within array | Excel Worksheet Functions | |||
| 'Time to Fix' Formula | Excel Discussion (Misc queries) | |||
Linear Mode
