+ Reply to Thread
Results 1 to 4 of 4

vlookup use with open ended range and array?

  1. #1
    Registered User
    Join Date
    01-20-2014
    Location
    Omaha
    MS-Off Ver
    Excel 2010
    Posts
    4

    vlookup use with open ended range and array?

    I have a vlookup funtcion that works for me in my workbook, when the data range and array is specific, but my data range will expand as will the array, as time goes on. I've used the "max" to help produce the most recent results. Is there a way to accomplish this with an ever changing range and array? The most recent date will always be added to the bottom of column "A." I've used =VLOOKUP(MAX(A4:A25),A4:B25,2,0)
    Attached Files Attached Files

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: vlookup use with open ended range and array?

    will this work for you

    Please Login or Register  to view this content.
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: vlookup use with open ended range and array?

    This is something that might work for you:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: vlookup use with open ended range and array?

    glad I could help...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How do you make an open-ended/dynamic range?
    By kestefon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-13-2013, 01:36 PM
  2. Open-ended list validation
    By m.cain in forum Excel General
    Replies: 1
    Last Post: 02-11-2008, 08:25 PM
  3. Average of open-ended column, within given intervals
    By chlor in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-03-2006, 10:58 AM
  4. Open Ended VBA Criteria
    By SamuelT in forum Excel General
    Replies: 8
    Last Post: 10-02-2006, 09:42 AM
  5. [SOLVED] Need open ended cell for Sum range.
    By Cris B. in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-14-2005, 12:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1