Hey CJ,

The problem is that you haven't anchored your data set. Use $ in the vlookup.

ex. =VLOOKUP(A1,$C$7:$H$38,3,FALSE)
--
-SA


"CJ" wrote:

I am using VLOOKUP to match a unique number from my Table A to a unique
number from Table B and return whatever it says in the 3rd column of Table B.
The first one worked great. But I need to copy that formula through an
entire column, and as I FILL it to other cells, it changes the array and
suddenly I get N/A# a lot. I have to go back and manually cut and paste the
array value into each formula and then they work. This is highly annoying. is
there anyway to tell Excel "Do not change this value - always keep this array
the same"?