Results 1 to 2 of 2

Aladin Akyurek's Lookup Construct to Return the Last Match

This is a discussion on Aladin Akyurek's Lookup Construct to Return the Last Match within the Hall of Fame Winners forums, part of the Other Forums category; Aladin provides a great worksheet function construct, orginally crafted by Harlan Grove, and example to return the last matched value ...

  1. Dec 8th, 2005, 08:05 PM #1
    NateO
    NateO is offline
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,702

    Default Aladin Akyurek's Lookup Construct to Return the Last Match

    Aladin provides a great worksheet function construct, orginally crafted by Harlan Grove, and example to return the last matched value here:

    http://www.mrexcel.com/board2/viewto...=501680#501680

    And he then provides an excellent, detailed explanation of that construct here:

    http://www.mrexcel.com/board2/viewto...=502525#502525

    Enjoy, and kudos, Aladin.
    Regards,
    Nate Oliver
    Microsoft Excel MVP
    Nate's Excel Blog
    Reply With Quote Reply With Quote
  2. Oct 29th, 2012, 12:04 PM #2
    starl
    starl is offline
    Administrator starl's Avatar
    Join Date
    Aug 2002
    Location
    Everywhere!
    Posts
    4,771

    Default Re: Aladin Akyurek's Lookup Construct to Return the Last Match

    new link to thread: Lookup for a value in Unsorted data
    ~Tracy~
    MrExcel Consulting
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


DMCA.com