+ Reply to Thread
Results 1 to 4 of 4

how to use index formula to lookup from bottom to top?

  1. #1
    Registered User
    Join Date
    11-20-2019
    Location
    nepal
    MS-Off Ver
    office 2016
    Posts
    20

    how to use index formula to lookup from bottom to top?

    Respected all,

    I love to use index and match formula for any lookup task, but for now, I have to lookup the last value from the column. Means, in the multiple same data in the array I would like to pick up the last data because it's the latest update in my file. as index and vlookup usually carry the first data that came across but I want the last one.

    kind regards,

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,147

    Re: how to use index formula to lookup from bottom to top?

    Try to follow this format:

    =LOOKUP(2,1/(Lookup_range=Lookup_value),Result_Range)

    with both has same dimension and a single range with same direction.

  3. #3
    Registered User
    Join Date
    11-20-2019
    Location
    nepal
    MS-Off Ver
    office 2016
    Posts
    20

    Re: how to use index formula to lookup from bottom to top?

    With all due respect,
    can we do the same thing using index and match formula?

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,147

    Re: how to use index formula to lookup from bottom to top?

    INDEX and MATCH is for 1st value seaching. Why not LOOKUP ?

+ 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. [SOLVED] Return Row no. for Lookup from bottom of range, ignoring bottom n no. of rows
    By naira in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 12-27-2018, 12:07 AM
  2. Lookup from bottom of range, ignoring bottom n no. of rows
    By naira in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-05-2018, 04:26 AM
  3. Help with adjusting Index lookup formula to include additional lookup criteria
    By kingofcamden in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-14-2018, 01:04 PM
  4. [SOLVED] Index from bottom to top
    By Moragtao in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-13-2017, 05:05 PM
  5. Replies: 4
    Last Post: 05-19-2015, 08:42 PM
  6. [SOLVED] Need INDEX MATCH formula that arranges Xs in bottom rows and then starts arranging ys
    By bkwins in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-05-2013, 09:16 AM
  7. Match/Index/Lookup - Searching From Bottom to Top (A reverse lookup maybe)
    By Neutralizer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-02-2013, 03:55 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