+ Reply to Thread
Results 1 to 3 of 3

Lookup last value with dynamic range

  1. #1
    Registered User
    Join Date
    01-26-2019
    Location
    London
    MS-Off Ver
    2016
    Posts
    11

    Lookup last value with dynamic range

    Hello all,

    Could you please help me on below.
    I am trying to Lookup a last value in row, but I can't make my range dynamic.

    Capture 1.PNG

    Whenever I tried to add a column, I have to modify and range as well.

    Capture 2.PNG

    Is it possible to make a range starting from a static cell and ending in active cell ??
    Something like from B2 to OFFSET(H$2,0,-1)) ?

    Thank you and best regards

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Lookup last value with dynamic range

    Does the result of your lookup absolutely need to be in the column after the last column with data?

    If not check http://www.xldynamic.com/source/xld.LastValue.html
    Last edited by Pepe Le Mokko; 01-28-2019 at 12:00 PM.

  3. #3
    Registered User
    Join Date
    01-26-2019
    Location
    London
    MS-Off Ver
    2016
    Posts
    11

    Re: Lookup last value with dynamic range

    Hi,
    Thanks for the source, will investigate it.
    Kind regards

+ 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. Vlookup with dynamic lookup range
    By limpopolondon in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 06-14-2018, 02:47 PM
  2. Lookup value wuth dynamic range
    By dobracik in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-20-2017, 12:35 PM
  3. Replies: 2
    Last Post: 01-20-2017, 04:27 PM
  4. Lookup formula against a dynamic range
    By andrewc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-26-2013, 07:12 AM
  5. using lookup and match in dynamic range
    By jrtaylor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-18-2011, 12:35 AM
  6. Lookup Against Dynamic Range Using VBA
    By dgo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2009, 08:44 AM
  7. Lookup with dynamic range
    By Ola Sigurdh in forum Excel General
    Replies: 4
    Last Post: 08-08-2005, 11:05 AM

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