Can you 'fix' an array of values for use with VLOOKUP

M

mavisB

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?
 
G

Gary Brown

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)
 
G

Gord Dibben

You can also give the table array a defined name.

=VLOOKUP(A1,myname,2,FALSE)


Gord Dibben MS Excel MVP
 
Top