VLOOKUP: copying formula - only returns same value for all cells

[muscles7]

I am attempting to pull a city's "county" from a table by using the zipcode. The formula works, but when attempting to copy the formula into the other cells. It still pulls the original zipcode from the first cell that was entered. I have dragged the formula using the "+" and used control + enter. So far that method has worked for other formulas I have entered. I am new at this, so I am not sure if I am needing to use another formula since its pulling an exact zipcode if that makes sense.


Formula I am using is : =VLOOKUP(1013,I17:K47757,3,FALSE)


1013 is the zipcode and placement I need the data to pull.

 

[philwojo]

Since you entered in a value it won't update or change when you drag it, only the lookup range (I17:K47757) will change when you drag it. Are you needing the 1013 to change to 1014, 1015, 1016, etc? Or are you asking something different?

 

[muscles7]

Since you entered in a value it won't update or change when you drag it, only the lookup range (I17:K47757) will change when you drag it. Are you needing the 1013 to change to 1014, 1015, 1016, etc? Or are you asking something different?

Yes, I am needing it to change to the next zipcode in the next cell below it.

here is a snapshot of the worksheet.
http://tinypic.com/r/nyigc1/9

 

[philwojo]

I can't look at external links hopefully someone else can help, sorry, work blocks my access.