INDEX MATCH with Final Value Return Change

[Morey]

Hello all,

If Array/Formula below returns a 2, change return to Released. Is it possible to integrate into formula below?

=IFERROR(INDEX('PR Report'!U:U,MATCH(A2&B2,'PR Report'!C:C&'PR Report'!E:E,0)),"")

Regards,

Morey

 

[Morey]

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(…),

,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 .

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

Morey

 

[Morey]

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

=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

 

[Morey]

Hello All,

Formula/Array below did the trick.

=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