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?

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?

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?

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?