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

1. ## INDEX MATCH with Final Value Return Change

Hello all,

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

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

Regards,

Morey

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

@Morey,

It might be beneficial if you could limit the rows rather than use full columns but maybe like....

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

Hope that helps.

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

Snakehips,

That definitely works on my end. Since, we are at it. How do I add an additional value change? For instance, 2 = Released and 3 = Pending.

Thank you,

Morey

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

Will your values always be numeric?
Also what should happen if the return is 1?

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

If the formula just returns small integers;

=IFERROR(CHOOSE(INDEX('PR Report'!U:U,MATCH(A2&B2,'PR Report'!C:C&'PR Report'!E:E,0)),[what to return for 1], [what to return for 2], [what to return for 3] etc),"")

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

Maybe try...

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

Confirm with Ctrl + Shift + Enter

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

Fluff,

Originally Posted by Fluff
Will your values always be numeric?
Also what should happen if the return is 1?
Oddly, not all values are numeric. D = In Review...

Morey

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

Snakehips,

Originally Posted by RossTattersall
If the formula just returns small integers;

=IFERROR(CHOOSE(INDEX('PR Report'!U:U,MATCH(A2&B2,'PR Report'!C:C&'PR Report'!E:E,0)),[what to return for 1], [what to return for 2], [what to return for 3] etc),"")
Originally Posted by RossTattersall
If the formula just returns small integers;

=IFERROR(CHOOSE(INDEX('PR Report'!U:U,MATCH(A2&B2,'PR Report'!C:C&'PR Report'!E:E,0)),[what to return for 1], [what to return for 2], [what to return for 3] etc),"")
The issue I'm running into is that one of the multiple values is alpha numeric (D = In Review). How can Alpha & Numeric both be accounted for under the same formula? Possible?

Morey

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

You could create a lookup table for the 2,3,D etc & then use that to return the text you want.

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

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),"")

## User Tag List

#### Posting Permissions

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