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

1. ## Re: INDEX MATCH with Final Value Return Change

Originally Posted by RossTattersall
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

2. ## 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

3. ## 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