1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

vlookup table array

Discussion in 'Ask an Excel Question' started by Sallylou92000, Nov 12, 2017.

  1. Sallylou92000

    Sallylou92000 New Member

    I have been using vlookup since 1995. Over the last few weeks I have not been getting the results I have expected and have discovered that copying the formula down, now changes the table array.
    In the past I have always dragged or double clicked the formula down to the bottom of my selection, and the table array has remained the area originally selected. Now the table array moves down which results in the vlookup not looking at all of the correct data.
    I know I am able to name the range which solves the problem, but for speed I prefer to just select the data whilst entering in the formula. (been doing it this way for 20 years)
    I am using excel 2016, and I'm wondering if an update may have caused the change?
    Any suggestions welcome...
  2. Chief Ace

    Chief Ace Member

    Did you lock your reference? Please look at sample attach.

    Attached Files:

  3. David Evans

    David Evans Active Member

    Are you certain that you didn't use Absolute Cell references, as opposed to Relative, in your previous work?

    I've not seen any changes in Excel versions that would suggest there's been a change of approach via an update, and more to the point, I think this place would have been inundated with questions had that been the case.

Share This Page