Results 1 to 2 of 2

Thread: vlookup base on a maximum/latest condition
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default vlookup base on a maximum/latest condition

    Hi guys,

    I am having trouble with a formula to determine the latest value on a vlookup. The following is an example:

    Apples ordered 2/4/2019
    Oranges backfilled 2/4/2019
    Apples arrived 3/4/2019
    Oranges arrived 3/4/2019
    Apples backstock 4/4/2019
    Oranges missing 4/4/2019

    I want to be able to write a formula thats based on the keyword "Apple" but look for the latest entry, so in this case, it will return "backstock".

    I cant get this to work with even index match... any help would be greatly appreciated!

    Thanks.!

  2. #2
    Board Regular CyrusTheVirus's Avatar
    Join Date
    Jan 2015
    Location
    Glens Falls, USA
    Posts
    732
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: vlookup base on a maximum/latest condition

    Try out the below. You can copy/paste the below table into excel so you see how it operates.

    F2 (Entered with Ctrl+Shift+Enter):
    Code:
    =INDEX($B$2:$B$7,MATCH(E2&MAX($C$2:$C$7*($A$2:$A$7=E2)),$A$2:$A$7&$C$2:$C$7,0))
    Type Result Dates Criteria Result
    Apples ordered 2/4/2019 Apples backstock
    Oranges backfilled 2/4/2019
    Apples arrived 3/4/2019
    Oranges arrived 3/4/2019
    Apples backstock 4/4/2019
    Oranges missing 4/4/2019
    Last edited by CyrusTheVirus; Apr 14th, 2019 at 08:39 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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