Thread: Can you 'fix' an array of values for use with VLOOKUP
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 With QuoteReply With Quote