INDEX MATCH with Final Value Return Change
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: INDEX MATCH with Final Value Return Change
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    New Member
    Join Date
    Sep 2018
    Posts
    27
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: INDEX MATCH with Final Value Return Change

    Quote Originally Posted by RossTattersall View Post
    I agree with Fluff in that case. Add a sheet with a table of what outcomes should lead to what outcomes and do something like;
    IFERROR(VLOOKUP(INDEX(…),[table],2,0),"")
    Ross,

    Below is the formula (return value & lookup table) that I'm using but, it returns a 0. I noticed in your suggestion you use VLOOKUP and INDEX. Is it possible to mix both of them?

    Possible to do something more like this? Currently, returns #VALUE .

    Code:
    =IF(VLOOKUP(A2,'PR Report'!C:Z,19,0),"",(VLOOKUP(K2,List!E:F,2,0)))

    Morey
    Last edited by Morey; Jun 21st, 2019 at 11:54 AM.

  2. #12
    New Member
    Join Date
    Sep 2018
    Posts
    27
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: INDEX MATCH with Final Value Return Change

    Possible to do something more like this? Locked out of editing above message. Forum posting is glitched in IE. Please, ignore above.

    Code:
    =IFERROR(VLOOKUP(INDEX('PR Report'!U:U,MATCH(A3&B3,'PR Report'!C:C&'PR Report'!E:E,0),"",(VLOOKUP(K2,List!E:F,2,0)))
    Morey
    Last edited by Morey; Jun 21st, 2019 at 12:11 PM.

  3. #13
    New Member
    Join Date
    Sep 2018
    Posts
    27
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: INDEX MATCH with Final Value Return Change

    Hello All,

    Formula/Array below did the trick.

    Code:
    =IFNA(INDEX(List!F:F,MATCH(INDEX('Report'!$U$1:$U$5000,MATCH(A2&B2,'Report'!$C$1:$C$5000&'Report'!$E$1:$E$5000,0)),List!E:E,0)),"")

    Regards,

    Morey

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
  •