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?