Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Limit to rows in Vlookup table? (2003)

    For some odd reason the lookup table is not going to the very bottom of the list i.e. To row A258 , instead it is stopping at row A213, is there a limit to the number of rows in a Vlook up function.

    See attachment for details.
    Attached Files Attached Files

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Limit to rows in Vlookup table? (2003)

    I am unaware of any lookup row or column limitation. The Vlookup formula you have in column B of Blue Sky limits the range to row 213, additionally the data validation in column A is limited to the named range 'City'. This range stops at row 213.
    Regards
    Don

  3. #3
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limit to rows in Vlookup table? (2003)

    Hello,

    I am confused , as it shows B258 in formula, what do l have to change in order for the dropdown to read from this row. See screenshot for formula l am using.
    Attached Images Attached Images

  4. #4
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Limit to rows in Vlookup table? (2003)

    1. <LI>Your formulae in Column B are not consistent B42 is =VLOOKUP(A42,Values!$A$4:$B$213,2,FALSE)
      <LI>To increase the validation list Pull down Insert > Name > Define; Select City; and revise =Values!$A$4:$A$213 to =Values!$A$4:$A$258
    H.T.H.
    Regards
    Don

  5. #5
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limit to rows in Vlookup table? (2003)

    Thatís great thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •