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